SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO
IF OBJECT_ID(N'dbo.TF_Split', N'TF') IS NOT NULL
DROP FUNCTION dbo.TF_Split;
GO
/**
author : doeyull.kim
e-mail : purumae@gmail.com
created date : 2009-07-10
description : ±¸ºÐÀÚ¸¦ °¡Áø ºñ À¯´ÏÄÚµå ¹®ÀÚ¿À» SplitÇÏ¿© Å×À̺í·Î ¹ÝȯÇÕ´Ï´Ù.
**/
CREATE FUNCTION dbo.TF_Split (
@vchString varchar(max),
@vchDelimiter varchar(10)
)
RETURNS @tblResult table (string varchar(8000) NOT NULL)
AS
BEGIN
DECLARE @xmlString xml;
SET @xmlString = CAST(N'' + REPLACE(@vchString, @vchDelimiter, '') + '' AS xml);
INSERT @tblResult (string)
SELECT N.value('.', 'varchar(8000)') FROM @xmlString.nodes('X') AS T(N)
RETURN;
END
GO
EXEC sp_addextendedproperty N'MS_Description', N'±¸ºÐÀÚ¸¦ °¡Áø ºñ À¯´ÏÄÚµå ¹®ÀÚ¿À» SplitÇÏ¿© Å×À̺í·Î ¹ÝȯÇÕ´Ï´Ù.', N'user', N'dbo', N'function', N'TF_Split';
EXEC sp_addextendedproperty N'MS_Description', N'±¸ºÐÀÚ¸¦ Æ÷ÇÔÇÑ ºñ À¯´ÏÄÚµå ¹®ÀÚ¿.', N'user', N'dbo', N'function', N'TF_Split', N'parameter', N'@vchString';
EXEC sp_addextendedproperty N'MS_Description', N'±¸ºÐÀÚ.', N'user', N'dbo', N'function', N'TF_Split', N'parameter', N'@vchDelimiter';
GO
IF OBJECT_ID(N'dbo.TF_NSplit', N'TF') IS NOT NULL
DROP FUNCTION dbo.TF_NSplit;
GO
/**
author : doeyull.kim
e-mail : purumae@gmail.com
created date : 2008-07-10
description : ±¸ºÐÀÚ¸¦ °¡Áø À¯´ÏÄÚµå ¹®ÀÚ¿À» SplitÇÏ¿© Å×À̺í·Î ¹ÝȯÇÕ´Ï´Ù.
**/
CREATE FUNCTION dbo.TF_NSplit (
@nvcString nvarchar(max),
@nvcDelimiter nvarchar(10)
)
RETURNS @tblResult table (string nvarchar(4000) NOT NULL)
AS
BEGIN
DECLARE @xmlString xml;
SET @xmlString = CAST(N''+REPLACE(@nvcString, @nvcDelimiter, N'')+N'' AS xml);
INSERT @tblResult (string)
SELECT N.value(N'.', 'nvarchar(4000)') FROM @xmlString.nodes(N'X') AS T(N)
RETURN;
END
GO
EXEC sp_addextendedproperty N'MS_Description', N'±¸ºÐÀÚ¸¦ °¡Áø À¯´ÏÄÚµå ¹®ÀÚ¿À» SplitÇÏ¿© Å×À̺í·Î ¹ÝȯÇÕ´Ï´Ù.', N'user', N'dbo', N'function', N'TF_NSplit';
EXEC sp_addextendedproperty N'MS_Description', N'±¸ºÐÀÚ¸¦ Æ÷ÇÔÇÑ À¯´ÏÄÚµå ¹®ÀÚ¿.', N'user', N'dbo', N'function', N'TF_NSplit', N'parameter', N'@nvcString';
EXEC sp_addextendedproperty N'MS_Description', N'±¸ºÐÀÚ.', N'user', N'dbo', N'function', N'TF_NSplit', N'parameter', N'@nvcDelimiter';
GO