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
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