SQL failed while converting the nvarchar value to the data type int.

Suppose there are stored procedures: proc_test2

Create proc Proc_test2

@Id int

Begin

As

DECLARE @sql varchar (max)

@sql = ' SELECT * from test2 where 1=1 '

If @Id <> 0

Set @sql + = ' and Id = ' +@Id

EXEC (@sql)

End

The parameters required by the stored procedure are of type int, and the direct value ([email protected]) is not a problem, but when executing the stored procedure, it pops up

"SQL failed when converting the nvarchar value to a data type int. ”

At this point you need to switch on the OK!

The positive solution is: set @sql + = ' and Id = ' +Cast (@Id as nvarchar ())

SQL failed while converting the nvarchar value to the data type int.