解析逗号分隔信息的字符串为表格
程序员文章站
2022-06-13 19:35:37
...
解析逗号分隔信息的字符串为表格 无 CREATE FUNCTION dbo.Parsecsvstr (@list VARCHAR(500))returns @tbl TABLE ( str VARCHAR(20))AS BEGIN DECLARE @valuelen INT, @pos INT, @nextpos INT SELECT @pos = 0, @nextpos = 1 WHILE @nextpos 0 BEGIN SELECT @n
解析逗号分隔信息的字符串为表格CREATE FUNCTION dbo.Parsecsvstr (@list VARCHAR(500)) returns @tbl TABLE ( str VARCHAR(20)) AS BEGIN DECLARE @valuelen INT, @pos INT, @nextpos INT SELECT @pos = 0, @nextpos = 1 WHILE @nextpos > 0 BEGIN SELECT @nextpos = Charindex(',', @list, @pos + 1) SELECT @valuelen = CASE WHEN @nextpos > 0 THEN @nextpos ELSE Len(@list) + 1 END - @pos - 1 INSERT @tbl (str) VALUES(Substring(@list, @pos + 1, @valuelen)) SELECT @pos = @nextpos END RETURN END