How do I create a truly empty xml element with the for xml-directive in sql server (2005)?
Example:
select
''
for xml path('element'), root('elements')
Outputs:
<elements><element></element></elements>
But what I really want is:
<elements><element /></elements>