Datakent Forum : SQL INT SPLIT http://forum.datakent.com/ XML içerik linki; Datakent Forum : Microsoft SQL Server : SQL INT SPLIT Sun, 19 Apr 2026 11:58:50 +0000 Sun, 19 Apr 2015 10:30:52 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.54 360 forum.datakent.com/RSS_post_feed.asp?TID=2788 Datakent Forum http://forum.datakent.com/forum_images/datakent.com_forums.png http://forum.datakent.com/ SQL INT SPLIT : CREATE FUNCTION .( @IDS varchar(MAX))RETURNS... http://forum.datakent.com/forum_posts.asp?TID=2788&PID=5629#5629 Yazar: murat turan
Konu: 2788
Gönderim Zamanı: 19.Nisan.2015 Saat 10:30

CREATE FUNCTION [dbo].[SqlSplit2Int]
(
@IDS varchar(MAX)
)
RETURNS @SqlTblSplit TABLE
(
rcid int
)
AS
BEGIN
DECLARE @String    VARCHAR(11)

    WHILE LEN(@IDS) > 0
    BEGIN
        SET @String      = LEFT(@IDS, 
                                ISNULL(NULLIF(CHARINDEX(',', @IDS) - 1, -1),
                                LEN(@IDS)))
        SET @IDS = SUBSTRING(@IDS,
                                     ISNULL(NULLIF(CHARINDEX(',', @IDS), 0),
                                     LEN(@IDS)) + 1, LEN(@IDS))

        INSERT INTO @SqlTblSplit ( rcid )
        VALUES ( CAST(@String AS INT) )
    END   

RETURN
END

-- KULLANIM
SELECT * FROM [dbo].[SqlSplit2Int] 
('1000000000,1000000002,1000000003,1000000004,1000000005,1000000006,1000000007,1000000008,1000000009')
]]> Sun, 19 Apr 2015 10:30:52 +0000 http://forum.datakent.com/forum_posts.asp?TID=2788&PID=5629#5629