executesql存储过程
来源：动视网
责编：小采
时间：2020-11-09 07:14:05
executesql存储过程
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 in
导读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 in
代码如下:
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
executesql存储过程
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 in
