Putting attribute on root node using FOR XML PATH & With XML NameSpaces
Hi, I'm new to the Sql. I have a query in which i need to include version = '3.0' attribute in the root node before the namespaces starts or end of the namespaces but should be in the root. Can any one help me Please.
this is my Query
Code:
WITH XMLNAMESPACES (DEFAULT 'http://www.w3.org/2002/06/xhtml2',
'http://www.w3.org/2001/XMLSchema-instance' AS xsi,
'http://technerd.co.nz/forms/delete' as del,