NuRoN Consulting, INC.

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

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

SQL scalar function: Util.dbo.CastXML

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

' + @Input + '

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

Description for SQL scalar function: Util.dbo.CastXML

Todo