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
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
@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
@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
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
----------------------------------------------------
SQL你玩活了,偑服!!