declare @int_count int
declare @nvar_sql nvarchar(2000)
set @nvar_sql='select ''@int_count''=count(*) from AUTHORS'
exec sp_executesql @nvar_sql
declare @nvar_sql nvarchar(2000)
set @nvar_sql='select ''@int_count''=count(*) from AUTHORS'
exec sp_executesql @nvar_sql
declare @nvar_sql nvarchar(2000)
set @nvar_sql='select @a=count(*) from testtbl' /*(这里的SQL语句实际上应该是动态的,这里是为了简便)*/
exec sp_executesql @nvar_sql,N'@a int output',@int_count output
select @int_count
declare @nvar_sql nvarchar(2000)
set @nvar_sql='select @a=count(*) from testtbl'
exec sp_executesql @nvar_sql,N'@a int output',@int_count output