复制代码 代码如下: 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
复制代码 代码如下: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