解析逗号分隔信息的字符串为表格
2020-11-09
来源：华佗健康网
解析逗号分隔信息的字符串为表格 无 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
解析逗号分隔信息的字符串为表格 <无> $velocityCount-->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