一箩筐

摘要： ALTER function [dbo].[my_split](@c varchar(4000),@split varchar(2)) returns @t table(id int identity(1,1),col varchar(500)) as begin while(charindex(@split,@c)<>0) begin insert @t(col) values (substring(@c,1,charindex(@split,@c)-1)) set @c = stuff(@c,1,charindex(@split,@c),'') end ins 阅读全文