34,587
社区成员
发帖
与我相关
我的任务
分享
DECLARE @sql NVARCHAR(1000),@OldOrder INT
--我需要拼一个sql语句,然后将查询的结果赋值给@OldOrder
SET @sql ='select set @OldOrder = 1'
EXEC(@sql)
--以上的写法不行,请教大家!!
declare @sql nvarchar(100),@OldOrder int
set @sql=N'select @OldOrder=count(*) from T'
exec sp_executesql @sql,N'@OldOrder int output',@OldOrder output
print @OldOrder
/*
10
*/
DECLARE @sql NVARCHAR(1000),@OldOrder INT
--我需要拼一个sql语句,然后将查询的结果赋值给@OldOrder
SET @sql =' set @OldOrder = 1'
EXEC SP_EXECUTESQL @SQL,N'@OLDORDER INT OUTPUT',@OLDORDER=@OLDORDER OUTPUT
SELECT @OLDORDER
--1
--是指this?
declare @sql nvarchar(100),@OldOrder int
set @sql=N'你的select sql'
exec sp_executesql @sql,N'@OldOrder int output',@OldOrder output
print @OldOrder
DECLARE @sql NVARCHAR(1000),@OldOrder INT
--我需要拼一个sql语句,然后将查询的结果赋值给@OldOrder
SET @sql ='select @OldOrder = 1'
exec sp_executesql @sql,N'@oldOrder int out',@OldOrder OUT
SELECT @OldOrder
DECLARE @sql NVARCHAR(1000),@OldOrder INT
select @OldOrder=1
SET @sql ='select @OldOrder ='+CAST(@OldOrder AS VARCHAR(20))
PRINT @sql
print @OldOrder