SQL实现Split功能

USE [Fosun_Star]
GO
/****** Object:  UserDefinedFunction [dbo].[fn_split]    Script Date: 2016/4/7 10:00:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER function [dbo].[fn_split](@inputstr varchar(8000), @seprator varchar(10))
returns @temp table (Result varchar(200))
as 
begin
  declare @i int
  set @inputstr = rtrim(ltrim(@inputstr))
  set @i = charindex(@seprator , @inputstr)
  while @i >= 1
  begin
    insert @temp values(left(@inputstr , @i - 1))
    set @inputstr = substring(@inputstr , @i + 1 , len(@inputstr) - @i)
    set @i = charindex(@seprator , @inputstr)
  end
  if @inputstr <> '\'
  insert @temp values(@inputstr)
  return 
end

调用

SELECT Result AS ProjectId FROM [dbo].[fn_split] ('2ff0e3bd-2c83-4427-a98e-ac4b653e4a81,89e2f3a7-08e4-455e-805a-b25c6b97a881',',')