CREATE FUNCTION dbo.SubFunction

(

)

RETURNS XML

WITH RETURNS NULL ON NULL INPUT

BEGIN

DECLARE @xml XML

;WITH XMLNAMESPACES

(

'http://www.example-namespace.com' AS ns

)

SELECT @xml=(

SELECT

'Example1' AS "ex1",

'Example2' AS "ex2"

FOR XML PATH('ns:SubPath')

)

RETURN @xml

END

GO

;WITH XMLNAMESPACES

(

'http://www.example-namespace.com' AS ns

)

SELECT

'Main' AS "ns:Main",

dbo.SubFunction()

FOR XML PATH ('ns:doc')

GO

DROP FUNCTION dbo.SubFunction