SQL语句如下：
DECLARE @temp varchar(50)
DECLARE @post int
DECLARE @endpost int
DECLARE @flag bit
SET @flag = 1
SET @post = 0
SET @temp='1,2,3,4,'
WHILE(@flag = 1)
BEGIN
SET @endpost = charindex(',',@temp)
IF(@endpost > 0)
BEGIN
INSERT INTO [str] (chr) VALUES (substring(@temp,1,@endpost-1))
SET @temp = right(@temp,len(@temp)-@endpost)
END
ELSE
BEGIN
IF(@temp <> '')
BEGIN
INSERT INTO [str] (chr) VALUES (@temp)
SET @flag = 0
END
ELSE
SET @flag = 0
END
END
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。