GO/****** Object:  UserDefinedFunction [dbo].[Fn_convertstringtotablestring3]    Script Date: 2020/5/20 16:38:28 ******/
SET ANSI_NULLS ON
GOSET QUOTED_IDENTIFIER ON
GO/*
** 将一个字符串转换成一个表变量。strvalue为字符形式
**/
ALTER function [dbo].[Fn_convertstringtotablestring3] (@String varchar(8000),--要转换的字符串。 @Separator varchar(10) = ',' --分隔符。
)
returns @Table table(strvalue varchar(500),seq      int identity(1, 1))
asbeginset @String = @String+@Separatorwhile Charindex(@Separator, @String)>0begininsert into @Table(strvalue)values     (Substring(@String, 1, Charindex(@Separator, @String)-1))select @String=Substring(@String, Charindex(@Separator, @String)+1, Len(@String)-Charindex(@Separator, @String))endreturnendGO