Sqlserver表值函数来获取逗号分隔的ID

2:定义表值函数：

USE [CRM_CN2]
GO
/****** Object:  UserDefinedFunction [dbo].[F_SPLIT]    Script Date: 2019/6/28 17:22:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
 =============================================
 Author:        <Author,,Name>
 Create date: <Create Date,,>
 Description:    <Description,,>
 =============================================
ALTER  FUNCTION [dbo].[F_SPLIT]
(
    @SourceSql nvarchar(4000),
    @StrSeprate varchar(10)
)
RETURNS @temp TABLE(Temp_Field nvarchar(2000))

AS
BEGIN
        declare @i int
        set @SourceSql = rtrim(ltrim(@SourceSql))
        
        set @i = charindex(@StrSeprate, @SourceSql)
        while @i >= 1
        begin
            insert @temp values(left(@SourceSql, @i - 1))
            set @SourceSql = substring(@SourceSql, @i + 1, len(@SourceSql) - @i)
            set @i = charindex(@StrSeprate, @SourceSql)
        end
        if @SourceSql <> ‘\‘
            insert @temp values(@SourceSql)
        RETURN
    END

Sqlserver表值函数来获取逗号分隔的ID

标签：sources   returns   object   ===   date   server   cti   crm   lse