I created the procedure listed below CREATE procedure getdata ID int frm varchar 250 to varchar 250 AS BEGIN DECLARE SQL nvarchar 500 set SQL select set SQL SQL EmpName Address Salary from Emp Tb where 1 1 IF ID lt gt and ID is not null Begin SET sql sql AND Emp Id Pk ID End END print sql --execute sql I try to execute it using execute getdata 3 But I m getting the following error Conversion failed when converting the nvarchar value select EmpName Address Salary from Emp Tb where 1 1 AND Emp Id Pk to data type int Please help

Conversion failed when converting the nvarchar value ... to data type int

You are trying to concatenate a string and an integer.
You need to cast @ID as a string.
try:

SET @[email protected]+' AND Emp_Id_Pk=' + CAST(@ID AS NVARCHAR(10))

~ Answered on 2014-02-09 04:10:22