¹ØÓÚ¶¯Ì¬¹¹Ôì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/