¹¤×÷ÖлýÔܵļ¸¸ö×Ô¶¨ÒåSQLº¯Êý

    ¹¤×÷ÖлýÔܵļ¸¸ö×Ô¶¨ÒåSQLº¯Êý:
-- =============================================
-- Author:  <Author,,Name>
-- Create date: <Create Date, ,>
-- Description: ×Ö·û´®ÇиÊý
-- =============================================
ALTER function [dbo].[Split]
(
 @Text nvarchar(4000),
 @Sign nvarchar(4000)
)
returns  @tempTable table(id int identity(1,1) primary key,[value] nvarchar(4000))
AS
begin
     declare @StartIndex int                --¿ªÊ¼²éÕÒµÄλÖÃ
     declare @FindIndex  int                --ÕÒµ½µÄλÖÃ
     declare @Content    varchar(4000)      --ÕÒµ½µÄÖµ
     set @StartIndex = 1
     set @FindIndex=0
   
      --±éÀúÿ¸ö×Ö·û
     while(@StartIndex <= len(@Text))
     begin
         SELECT @FindIndex = charindex(@Sign,@Text,@StartIndex)
         --ÅжÏÓÐûÕÒµ½ ûÕÒµ½·µ»Ø0
        IF(@FindIndex =0 OR @FindIndex IS NULL)
        begin
            set @FindIndex = len(@Text)+1
        end
        set @Content = ltrim(rtrim(substring(@Text,@StartIndex,@FindIndex-@StartIndex)))
        set @StartIndex = @FindIndex+1
        insert into @tempTable ([value]) values (@Content)
     end
       return
end
-- ==========