executesql 存储过程

复制代码 代码如下:

declare @tt varchar(20)

set @tt = ‘monisubbouns’

declare @int int

declare @sql nvarchar(500)

set @sql = ‘select @int=count(*) from ‘ + @tt

exec sp_executesql @sql,n’@int int output’,@int output

print @int