SQL Server 实现Split函数

添加一个表值函数。

 

 1 CREATE function [dbo].[fnSplit]
 2 (
 3     @str nvarchar(4000),      --要分割的字符串
 4     @StrSeprate nvarchar(10)          --字符串之间的分隔符
 5 )   
 6 returns @temp table(Id int identity(1,1), TempName nvarchar(100)) 
 7 as  
 8 begin 
 9     declare @i int;
10     set @str=rtrim(ltrim(@str)); 
11     set @i=charindex(@StrSeprate, @str); 
12     while (@i>0) 
13         begin 
14             insert @temp values(left(@str,@i-1)); 
15             set @str = substring(@str, @i+1, len(@str)-@i); 
16             set @i=charindex(@StrSeprate, @str);
17         end 
18     insert @temp values(@str);
19     return;
20 end

 

转载于:https://www.cnblogs.com/bigbrid/p/6668766.html