时间:2021-07-01 10:21:17 帮助过:30人阅读
解析逗号分隔信息的字符串为表格 无 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