NuRoN Consulting, INC.

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

Blog > SQL Tools > Template Scripts > XML > Print Large Text with XML

Template Script: XML\Print Large Text with XML.sql

SELECT Field as '---- SQL ----' FROM Util.dbo.ParseDelimited(@SQL, '
')

DECLARE @sql VARCHAR(MAX) = 'gokhan>7'
SELECT 1 AS tag, NULL AS parent, '

' + @SQL + '

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

-- OR

SELECT
    1 AS Tag,
    NULL AS Parent,
    NULL AS 'SQLs!1',
    NULL AS 'SQL!2!SQLID!cdata'
UNION ALL
SELECT
    2 AS Tag,
    1 AS Parent,
    NULL as SQL,
    '

' + @sql + '

' as SQLID
FOR XML EXPLICIT, TYPE

Description for Template Script: XML\Print Large Text with XML.sql

Todo