title: Conversion failed when converting the nvarchar value ... to data type int
body: <p>I created the procedure listed below:</p>
  
  <pre><code>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)
  </code></pre>
  
  <p>I try to execute it using:</p>
  
  <pre><code>**execute getdata 3,'','';**
  </code></pre>
  
  <p>But I'm getting the following error:</p>
  
  <blockquote>
    <p>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</p>
  </blockquote>
  
  <p>Please help.</p>