表值函数输入即输出内容

最新推荐文章于 2024-05-07 10:26:13 发布

YIGEMOGUTOU1105

最新推荐文章于 2024-05-07 10:26:13 发布

阅读量94

点赞数

文章标签：数据库

本文链接：https://blog.csdn.net/weixin_47053243/article/details/125925634

版权

USE [UVIVIEW]
GO

/****** Object:  UserDefinedFunction [dbo].[f_split]    Script Date: 07/22/2022 09:27:34 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE   FUNCTION [dbo].[f_split]
    (
      @c VARCHAR(2000) ,
      @split VARCHAR(2)
    )
RETURNS @t TABLE ( col VARCHAR(20) )
AS
    BEGIN     
        WHILE ( CHARINDEX(@split, @c) <> 0 )
            BEGIN   
                INSERT  @t
                        ( col
                        )
                VALUES  ( SUBSTRING(@c, 1, CHARINDEX(@split, @c) - 1)
                        );   
                SET @c = STUFF(@c, 1, CHARINDEX(@split, @c), '');   
            END;   
        INSERT  @t
                ( col )
        VALUES  ( @c );   
        RETURN;   
    END;

GO