关于动态构造sql - MS-SQL Server / 基础类

SQL code:
declare
@s varchar(1000)
set @s = '1,23,a'
declare
@sql varchar(1000)
declare
@temptb table(IDList varchar(8000))
set @sql = 'select col= '''
+ replace(@s,',','''union all select ''')
+ ''''
print (@sql)
exec (@sql)



这里的结果我如何拿出来用啊

---

SQL code:
输出参数
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 output',@num output
select @num

---

SQL code:
create table #(col varchar(10))
declare
@s varchar(1000)
set @s = '1,23,a'
declare
@sql varchar(1000)
declare
@temptb table(IDList varchar(8000))
set @sql = 'insert # select col= '''
+ replace(@s,',','''union all select ''')
+ ''''
print (@sql)

exec (@sql)
select * from #
/*
col
----------
1
23
a

(3 行受影响)
*/

---

可以放到临时表中再拿出来用

---

SQL code

---

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/