循环保存

[sisiz]

有个字符串 str=1#2#3

怎么把他循环保存到表里

FOR(i=0;i<2;i++)
{
INSERT INTO TongJiPiCi(strID)
VALUES(@STR_Hao)
}

table
1
2
3

[水族杰纶]

create function dbo.fn_split 
( 
@inputstr varchar(8000), 
@seprator varchar(10) 
) 
returns @temp table (a varchar(200)) 
as 
begin 
declare @i int 
set @inputstr = rtrim(ltrim(@inputstr)) 
set @i = charindex(@seprator, @inputstr) 
while @i >= 1 
begin 
insert @temp values(left(@inputstr, @i - 1)) 
set @inputstr = substring(@inputstr, @i + 1, len(@inputstr) - @i) 
set @i = charindex(@seprator, @inputstr) 
end 
if @inputstr <> '\' 
insert @temp values(@inputstr) 
return 
end 
go 
--调用 
declare @s varchar(1000) 
set @s='1#2#3' 
INSERT INTO  TongJiPiCi(strID) select a  from dbo.fn_split(@s,'#') 
drop function dbo.fn_split 

[ChinaJiaBing]

ooo

[spark_wu]

string s = "1#2#3#4";
string[] ss = s.Split('#');
foreach (string item in ss)
{
INSERT INTO TongJiPiCi(strID)
VALUES('item')
}

[sisiz]

表里还有其他字段INSERT INTO TongJiPiCi(strID) select a from dbo.fn_split(@s,'#')
就不行吧

[水族杰纶]

[Quote=引用 4 楼 sisiz 的回复:]
表里还有其他字段INSERT INTO TongJiPiCi(strID) select a from dbo.fn_split(@s,'#')
就不行吧
[/Quote]
拿數據說吧~~~~~~~~~

[百年树人]

create table TongJiPiCi(strID int)

declare @str varchar(100)
declare @STR_Hao int
set @str='1#2#3' 
set @str=@str+'#'
while charindex('#',@str)>0
begin
  set @STR_Hao=cast(left(@str,charindex('#',@str)-1) as int)
  INSERT INTO TongJiPiCi(strID) VALUES(@STR_Hao)
  set @str=substring(@str,charindex('#',@str)+1,len(@str))
end

select * from TongJiPiCi

/**
strID       
----------- 
1
2
3

（所影响的行数为 3 行）
**/

[lgxyz]

create table TongJiPiCi(strID int)

declare @str varchar(100)
declare @STR_Hao int
set @str='1#2#3' 
set @str=@str+'#'
while charindex('#',@str)>0
begin
  set @STR_Hao=cast(left(@str,charindex('#',@str)-1) as int)
  if not exists(select * from TongJiPiCi where strID=@STR_Hao)
    insert  TongJiPiCi  select @STR_Hao
  set @str=stuff(@str,1,charindex('#',@str),'')
end

select * from TongJiPiCi

/*
strID       
----------- 
1
2
3

（所影响的行数为 3 行）
*/