NuRoN Consulting, INC.

File Download
Donate for FREE Code
SQL Tools
- Databases
- Template Scripts

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

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

CREATE FUNCTION dbo.CastXMLInline (@Input VARCHAR(MAX))
RETURNS TABLE
    AS
    RETURN
    SELECT  CASE WHEN @Input <> '' THEN (SELECT 1 AS tag, NULL AS parent, '

' + @Input + '

' AS [Q!1!Q!CDATA]
                      FOR                XML EXPLICIT,
                                             TYPE)
            END AS XMLOut

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

Todo