34,593
社区成员
发帖
与我相关
我的任务
分享
declare @num int, @sqls nvarchar(4000)
set @sqls='select count(*) from tableName'
exec(@sqls)
--如何将exec执行结果放入变量中?
declare @num int, @sqls nvarchar(4000)
set @sqls='select @a=count(*) from tableName '
exec sp_executesql @sqls,N'@a int ',@num
select @num
DECLARE @CKDMSQL nvarchar(200)
DECLARE @CKDM nvarchar(100)
SET @CKDMSQL='select top 5 Name from sysobjects'
DECLARE @T TABLE(SHCode NVARCHAR(50))
INSERT @T execute sp_executesql @CKDMSQL
SELECT * FROM @T
/*
sysrowsetcolumns
sysrowsets
sysallocunits
sysfiles1
syshobtcolumns
*/
DECLARE @CKDMSQL nvarchar(200)
DECLARE @CKDM nvarchar(100)
SET @CKDMSQL='select SHCode from tb_storehouse'
DECLARE @T TABLE(SHCode NVARCHAR(50))
INSERT @T execute sp_executesql @CKDMSQL
SELECT * FROM @T