分割字符串的问题

[purexiafeng]

如：@str ='1,2,3,4,5,9'分割出来
然后插到一张表中
表结构如下：
CREATE TABLE IDS
(
IDS INT,
IDNAME VARCHAR(50)
)

将上面的写到一个存储过程中。
请大家帮帮忙！

[purexiafeng]

数字都放到IDS字段中！

[子陌红尘]

CREATE TABLE IDS
(
IDS INT,
IDNAME VARCHAR(50)
)
go

create procedure sp_test(@str varchar(8000))
as
begin
while charindex(',',@str)>0
begin
insert into IDS(IDS) select left(@str,charindex(',',@str)-1)
set @str=stuff(@str,1,charindex(',',@str),'')
end
insert into IDS(IDS) select @str
end
go

exec sp_test '1,2,3,4,5,9'

select * from IDS
go

drop procedure sp_test
drop table IDS
go

[子陌红尘]

CREATE TABLE IDS
(
IDS INT,
IDNAME VARCHAR(50)
)
go

create procedure sp_test(@str varchar(8000))
as
begin
while charindex(',',@str)>0
begin
insert into IDS(IDS) select left(@str,charindex(',',@str)-1)
set @str=stuff(@str,1,charindex(',',@str),'')
end
insert into IDS(IDS) select @str
end
go

exec sp_test '1,2,3,4,5,9'

select * from IDS

/*
IDS IDNAME
----------- --------------------------------------------------
1 NULL
2 NULL
3 NULL
4 NULL
5 NULL
9 NULL
*/
go

drop procedure sp_test
drop table IDS
go