sql .Split

最新推荐文章于 2024-09-20 20:49:53 发布

sound02

最新推荐文章于 2024-09-20 20:49:53 发布

阅读量372

点赞数

文章标签： sql date insert c function object

本文链接：https://blog.csdn.net/sound02/article/details/6883848

版权

USE [QPRS]
GO
/****** Object: UserDefinedFunction [dbo].[Split]    Script Date: 10/18/2011 11:16:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:  sound
-- Create date: 2011/11/05
-- Description: 分割成In能用的數據如 in('1','3','5','7')
-- =============================================
-- Change History
-- ---------------------------------------------
-- Modifier: <Modifier 1,,> Date: <Modify Date 1,,>
-- Description:
-- Modifier: <Modifier 2,,> Date: <Modify Date 2,,>
-- Description:
-- =============================================
ALTER   FUNCTION [dbo].[Split]
(
@c VARCHAR(MAX) ,
@split VARCHAR(50)
)
RETURNS @t TABLE ( col VARCHAR(50) )
AS
BEGIN
SET @c=Replace(@c,'''','')
    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