CREATE function [dbo].[fnSplit]

 (

     @str nvarchar(4000),      --要分割的字符串

     @StrSeprate nvarchar(10)          --字符串之间的分隔符

 )

 returns @temp table(Id int identity(1,1), TempName nvarchar(100))

 as

 begin

     declare @i int;

     set @str=rtrim(ltrim(@str));

     set @i=charindex(@StrSeprate, @str);

     while (@i>0)

         begin

             insert @temp values(left(@str,@i-1));

             set @str = substring(@str, @i+1, len(@str)-@i);

             set @i=charindex(@StrSeprate, @str);

         end

     insert @temp values(@str);

     return;

 end