--参考:输出参数
DECLARE @num INT, @sqls NVARCHAR(4000)
SET @sqls='SELECT COUNT(1) 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 OUTPUT', @num OUTPUT
SELECT @num
-- 如何将拼接的语句输出到表变量中去?
DECLARE @Ids VARCHAR(MAX) = '97325,39646,2414,142590,142524,142737,4224 ,144110,52649 '
DECLARE @Table TABLE (Id INT)
DECLARE @sql NVARCHAR(MAX) = ''
SET @sql='SELECT COL='''+ REPLACE(@Ids,',',''' UNION ALL SELECT ''')+''''
-- 将执行结果存入表变量中
INSERT INTO @Table
EXEC sp_Executesql @sql
--输出结果
SELECT * FROM @Table
如何将exec执行结果放入变量中
最新推荐文章于 2023-05-24 14:58:50 发布