颠倒咯

[wwwhch2004]

有字符串"a,b,c,d,e,f,g"
如何将其用SQL语句插入到表N_ty中
如:
id Name_Code
1 a
2 b
3 c
...

[jinjazz]

declare @s varchar(1000)
set @s='a,b,c,d,e,f,g'
set @s='insert into N_ty select '''+replace(@s,',',''' union select ''')+''''
exec(@s)

[xiajianfeng]

--Try
CREATE FUNCTION SplitStr1 (@splitString varchar(8000), @separate varchar(10))
RETURNS @returnTable table(num int, col_Value varchar(20))
AS

BEGIN

declare @thisSplitStr varchar(20)
declare @thisSepIndex int
declare @lastSepIndex int
declare @num int

set @lastSepIndex = 0
set @num = 1

if Right(@splitString ,len(@separate)) <> @separate set @splitString = @splitString + @separate
set @thisSepIndex = CharIndex(@separate,@splitString ,@lastSepIndex)

while @lastSepIndex <= @thisSepIndex
begin
set @thisSplitStr = SubString(@splitString ,@lastSepIndex,@thisSepIndex-@lastSepIndex)
set @lastSepIndex = @thisSepIndex + 1
set @thisSepIndex = CharIndex(@separate,@splitString ,@lastSepIndex)
insert into @returnTable values(@num, @thisSplitStr)
set @num = @num + 1
end
return

END

INSERT INTO N_ty SELECT * FROM dbo.SplitStr1('a,b,c,d,e,f,g', ',')

[xluzhong]

declare @s nvarchar(1000)
set @s='a,b,c,d,e,f,g'
set @s='create table ##t (id int identity(1,1),col nvarchar(10)) insert into ##t(col) select '''+replace(@s,',',''' as col union all select ''')+''' select * from ##t drop table ##t'
exec(@s)

[子陌红尘]

用楼上jinjazz(近身剪（N-P攻略）) 的方法即可。

[wwwhch2004]

谢各位革命同志