SET @split = ','
set @originalStrSN = @SN+@split
WHILE (@originalStrSN <> '' )
begin
------取出每一个,前边的内容
SET @resultSN = LEFT(@originalStrSN, CHARINDEX(@split, @originalStrSN, 1) -1)
-------每一次去除一个,前边的内容
SET @originalStrSN = STUFF(@originalStrSN, 1, CHARINDEX(@split, @originalStrSN, 1), '')
end
set @i = @i + 1