Declare @s varchar(100),@s1 varchar(1000) Set @s='901,101,56,25,1,786' Set @s1='' Select @s1='Select '+@s1+replace(@s,',',' Union All Select ' ) Print @s1 Exec(@s1)
declare @a varchar(1000) set @a='901,101,56,25,1,786' set @a='select '+replace(@a,',',' union all select ') exec(@a)
还是???? Declare @s varchar(100),@s1 varchar(1000) Set @s='901,101,56,25,1,786' Set @s=replace(@s,',',char(13)) Print @s ---结果 /* 901 101 56 25 1 786 */
Set @s='901,101,56,25,1,786'
Set @s1=''
Select @s1='Select '+@s1+replace(@s,',',' Union All Select ' )
Print @s1
Exec(@s1)
set @a='901,101,56,25,1,786'
set @a='select '+replace(@a,',',' union all select ')
exec(@a)
Declare @s varchar(100),@s1 varchar(1000)
Set @s='901,101,56,25,1,786'
Set @s=replace(@s,',',char(13))
Print @s
---结果
/*
901
101
56
25
1
786
*/