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

Question

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 <> '' 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.

Answer 1

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

SET @sql=@sql+' AND Emp_Id_Pk=' + CAST(@ID AS NVARCHAR(10))