NuRoN Consulting, INC.

Blog > SQL Tools > Databases > Util > Functions > dbo.ParseDelimitedColumns64

Dependencies for SQL inline table-valued function: Util.dbo.ParseDelimitedColumns64

ReferencingFQN	ReferencingType	ReferencedFQN	ReferencedType	Depth	RedHierarchy
Util.dbo.ParseDelimitedColumns64	SQL inline table-valued function	Util.dbo.ParseDelimitedColumns64_CLR	Assembly (CLR) table-valued function	1	[Util].[dbo].[ParseDelimitedColumns64_CLR]
Util.dbo.ParseDelimitedColumns64_CLR	Assembly (CLR) table-valued function	Util.UtilClr	ASSEMBLY	2	[Util].[dbo].[ParseDelimitedColumns64_CLR], [Util].[UtilClr]

SQL inline table-valued function: Util.dbo.ParseDelimitedColumns64

CREATE FUNCTION [dbo].ParseDelimitedColumns64(@record NVARCHAR(MAX), @delim NVARCHAR(255))
RETURNS TABLE
AS
RETURN
SELECT
    CAST(C1 AS VARCHAR(MAX)) AS C1,
    CAST(C2 AS VARCHAR(MAX)) AS C2,
    CAST(C3 AS VARCHAR(MAX)) AS C3,
    CAST(C4 AS VARCHAR(MAX)) AS C4,
    CAST(C5 AS VARCHAR(MAX)) AS C5,
    CAST(C6 AS VARCHAR(MAX)) AS C6,
    CAST(C7 AS VARCHAR(MAX)) AS C7,
    CAST(C8 AS VARCHAR(MAX)) AS C8,
    CAST(C9 AS VARCHAR(MAX)) AS C9,
    CAST(C10 AS VARCHAR(MAX)) AS C10,
    CAST(C11 AS VARCHAR(MAX)) AS C11,
    CAST(C12 AS VARCHAR(MAX)) AS C12,
    CAST(C13 AS VARCHAR(MAX)) AS C13,
    CAST(C14 AS VARCHAR(MAX)) AS C14,
    CAST(C15 AS VARCHAR(MAX)) AS C15,
    CAST(C16 AS VARCHAR(MAX)) AS C16,
    CAST(C17 AS VARCHAR(MAX)) AS C17,
    CAST(C18 AS VARCHAR(MAX)) AS C18,
    CAST(C19 AS VARCHAR(MAX)) AS C19,
    CAST(C20 AS VARCHAR(MAX)) AS C20,
    CAST(C21 AS VARCHAR(MAX)) AS C21,
    CAST(C22 AS VARCHAR(MAX)) AS C22,
    CAST(C23 AS VARCHAR(MAX)) AS C23,
    CAST(C24 AS VARCHAR(MAX)) AS C24,
    CAST(C25 AS VARCHAR(MAX)) AS C25,
    CAST(C26 AS VARCHAR(MAX)) AS C26,
    CAST(C27 AS VARCHAR(MAX)) AS C27,
    CAST(C28 AS VARCHAR(MAX)) AS C28,
    CAST(C29 AS VARCHAR(MAX)) AS C29,
    CAST(C30 AS VARCHAR(MAX)) AS C30,
    CAST(C31 AS VARCHAR(MAX)) AS C31,
    CAST(C32 AS VARCHAR(MAX)) AS C32,
    CAST(C33 AS VARCHAR(MAX)) AS C33,
    CAST(C34 AS VARCHAR(MAX)) AS C34,
    CAST(C35 AS VARCHAR(MAX)) AS C35,
    CAST(C36 AS VARCHAR(MAX)) AS C36,
    CAST(C37 AS VARCHAR(MAX)) AS C37,
    CAST(C38 AS VARCHAR(MAX)) AS C38,
    CAST(C39 AS VARCHAR(MAX)) AS C39,
    CAST(C40 AS VARCHAR(MAX)) AS C40,
    CAST(C41 AS VARCHAR(MAX)) AS C41,
    CAST(C42 AS VARCHAR(MAX)) AS C42,
    CAST(C43 AS VARCHAR(MAX)) AS C43,
    CAST(C44 AS VARCHAR(MAX)) AS C44,
    CAST(C45 AS VARCHAR(MAX)) AS C45,
    CAST(C46 AS VARCHAR(MAX)) AS C46,
    CAST(C47 AS VARCHAR(MAX)) AS C47,
    CAST(C48 AS VARCHAR(MAX)) AS C48,
    CAST(C49 AS VARCHAR(MAX)) AS C49,
    CAST(C50 AS VARCHAR(MAX)) AS C50,
    CAST(C51 AS VARCHAR(MAX)) AS C51,
    CAST(C52 AS VARCHAR(MAX)) AS C52,
    CAST(C53 AS VARCHAR(MAX)) AS C53,
    CAST(C54 AS VARCHAR(MAX)) AS C54,
    CAST(C55 AS VARCHAR(MAX)) AS C55,
    CAST(C56 AS VARCHAR(MAX)) AS C56,
    CAST(C57 AS VARCHAR(MAX)) AS C57,
    CAST(C58 AS VARCHAR(MAX)) AS C58,
    CAST(C59 AS VARCHAR(MAX)) AS C59,
    CAST(C60 AS VARCHAR(MAX)) AS C60,
    CAST(C61 AS VARCHAR(MAX)) AS C61,
    CAST(C62 AS VARCHAR(MAX)) AS C62,
    CAST(C63 AS VARCHAR(MAX)) AS C63,
    CAST(C64 AS VARCHAR(MAX)) AS C64
FROM [dbo].ParseDelimitedColumns64_CLR(@record, @delim)

Description for SQL inline table-valued function: Util.dbo.ParseDelimitedColumns64

Todo