how to Check whether entered parameter is string or int

Try isnumeric funtion

http://stackoverflow.com/questions/9286152/using-if-isnumeric-as-argument

 USE AdventureWorks2012; 
 GO 
 SELECT City, PostalCode  FROM Person.Address  WHERE ISNUMERIC(PostalCode)<> 1; 
 GO

Please accept and up vote if it helped you
Kindest Regards
Sibeesh
http://sibeeshpassion.com/