Here is the solution to add parameters and curresponding to the Dynamic SQL.
-----------------------------------------------------------
Declare @createdate datetime
Declare @Str NVARCHAR(255)
declare @Param NVARCHAR(255)
set @Param = '@createdate datetime'
SET @Str = 'SELECT * from table_name ' +
' where CreationDate = @createdate AND ' +
' ID = Number'
EXECUTE sp_executesql @sql , @Param , @createdate
---------------------------------------------------------------
|
