解析逗号分隔信息的字符串为表格 无 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