using sp_executesql

T-SQL Programming Part 4 - Setting Variables in Calling T-SQ... use

use Northwind
go
declare @RECCNT int
declare @ORDID varchar(10)
declare @CMD Nvarchar(100)
set @ORDID = 10436
SET @CMD = 'SELECT @RECORDCNT=count(*) from [Orders]' +
         ' where OrderId < @ORDERID' print @CMD exec sp_executesql @CMD,                   N'@RECORDCNT int out, @ORDERID int',                   @RECCNT out,                   @ORDID  print 'The number of records that have an OrderId' +       ' greater than ' + @ORDID + ' is ' +      cast(@RECCNT as char(5))