DECLARE @i AS INT
DECLARE @n AS INT
DECLARE @s1 AS VARCHAR(255)
SELECT @i=len(sr1) FROM ts_2
SET @n=1
WHILE @n < @i
BEGIN
IF (SELECT RIGHT(sr1,1) FROM ts_2)=','
UPDATE ts_2 SET sr1=substring(sr1,1,@i-1)
SET @n=@n+1
SET @i=@i-1
END
SELECT * FROM ts_2
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ号：24596024