SQL 以逗号分隔查询;调用自定义函数

 select col from [dbo].[GetInPara]('101,102,103',',')

USE [xxx]

GO

/****** Object:  UserDefinedFunction [dbo].[GetInPara]    Script Date: 2019/9/26 11:06:28 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER   function   [dbo].[GetInPara](@c varchar(),@split varchar())

returns  @t   table(col   varchar())

as

    begin

      while(charindex(@split,@c)<>)

        begin

          insert   @t(col)   values   (substring(@c,,charindex(@split,@c)-))

          set   @c   =   stuff(@c,,charindex(@split,@c),'')

        end

      insert   @t(col)   values   (@c)

      return

    end