34,576
社区成员
发帖
与我相关
我的任务
分享
declare @num int,
@sqls nvarchar(4000)
set @sqls='select count(*) from tablename'
exec(@sqls)
declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from tablename'
exec sp_executesql @sqls,N'@a int output',@num output
select @num
N'@a int output,@b int output',@num1 output,@num2 output
@a ⇒@num1
@b ⇒@num2
N'@a int output,@b int output',@num2 output,@num1 output
@a ⇒@num2
@b ⇒@num1
declare @num1 int,@num2 int, @sqls nvarchar(4000)
set @sqls='select @a=count(*) ,@b=min(ID) from master.dbo.sysobjects'
exec sp_executesql @sqls,N'@a int output,@b int output',@num1 output,@num2 output
select @num1,@num2
go
declare @num1 int,@num2 int, @sqls nvarchar(4000)
set @sqls='select @a=count(*) ,@b=min(ID) from master.dbo.sysobjects'
exec sp_executesql @sqls,N'@a int output,@b int output',@num2 output,@num1 output
select @num1,@num2
declare @num int,
@sqls nvarchar(4000)
set @sqls='select @a=count(*) from tablename'
exec sp_executesql @sqls,N'@a int output',@num output
select @num