SQL小代码：字串转为表变量

Declare @List varchar(max)Declare @Delimeter varchar(1)---这里修改参数Select @List='1,2,3',   --字串的内容           @Delimeter=','  --字串的分隔符Declare @counter int, @item varchar(200)Declare @t table (item varchar(200))Set @counter = 0 --防止死循环if  right(@List,1) != @Delimeter    set @List = @List+@DelimeterWhile CharIndex( @Delimeter, @List)>0 and @counter<300 --循环300次，完不完成都出来Begin     Set @counter = @counter +1     Set @item = substring(@List, 1, CharIndex( @Delimeter, @List))     if len(@List)=CharIndex( @Delimeter, @List)             set @List = ''     else              set @List = Right(@List, len(@List)-CharIndex( @Delimeter, @List))    set @item = ltrim(rtrim(replace(@item,@Delimeter,'')))    insert into @t (item) values(@item)End--输出结果select * from @t