sp_executesql用法
DECLARE @SQLString NVARCHAR(4000)
declare @2 int
SET @SQLString =
N'SELECT @2=id FROM master.dbo.sysobjects WHERE id = 1'
EXECUTE sp_executesql @SQLString, N'@2 int output ',@2
select @2
为什么@2为NULL
-----------
NULL
(所影响的行数为 1 行)
SELECT id FROM master.dbo.sysobjects WHERE id = 1
id
-----------
1
(所影响的行数为 1 行)