CREATE PROC p_insert
@s varchar(8000) --处理的字符串
AS
BEGIN
WHILE CHARINDEX('%,%',@s)>0
BEGIN
INSERT (id) VALUES(LEFT(@s,CHARINDEX('%,%',@s)-1))
SET @s=STUFF(@s,1,CHARINDEX('%,%',@s),'')
END
INSERT (id) VALUES(@s)
END
GO
CREATE PROC p_insert
@s varchar(8000) --处理的字符串
AS
BEGIN
WHILE CHARINDEX(',',@s)>0
BEGIN
INSERT (id) VALUES(LEFT(@s,CHARINDEX(',',@s)-1))
SET @s=STUFF(@s,1,CHARINDEX(',',@s),'')
END
INSERT (id) VALUES(@s)
END
GO
CREATE PROC p_insert
@s varchar(8000) --处理的字符串
AS
BEGIN
WHILE CHARINDEX(',',@s)>0
BEGIN
INSERT (id) VALUES(LEFT(@s,CHARINDEX(',',@s)-1))
SET @s=STUFF(@s,1,CHARINDEX(',',@s),'')
END
INSERT (id) VALUES(@s)
END
GO
CREATE PROC p_insert
@s varchar(8000) --处理的字符串
AS
BEGIN
WHILE CHARINDEX('%,%',@s)>0
BEGIN
INSERT (id) VALUES(LEFT(@s,CHARINDEX('%,%',@s)-1))
SET @s=STUFF(@s,1,CHARINDEX('%,%',@s),'')
END
INSERT (id) VALUES(@s)
END