NuRoN Consulting, INC.

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

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

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

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

CREATE FUNCTION [dbo].ParseDelimitedColumns16(@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
FROM [dbo].ParseDelimitedColumns16_CLR(@record, @delim)

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

Todo