declare @sql nvarchar(1000),@id int
set @sql='select @row=count(*) from [table]'exec sp_executesql @sql,N'@row int output',@id output
select @id 结果
set @sql='select @row=count(*) from [table]'exec sp_executesql @sql,N'@row int output',@id output
select @id 结果
set @sql = 'Select @row=count(*) from table'
exec sp_executesql @sql,N'@row int output',@row output
select @row
[交流]动态SQL语句
exec sp_executesql N'select @row=count(*) from table',N'@row int out',@row out
--注意,第一个参数和第二个参数,必须是unicode类型的.所以字符串前加N
set @sql='N'select @row=count(*) from table'declare @row int
exec sp_executesql @sql,N'@row int out',@row out