XML : sql server for xml pevert direct closed market

everyone. first question in stack overflow.

DECLARE @xml XML= ( SELECT N'' AS [content1/*] , N'' AS [content2/*] FOR XML PATH('Rows') )

SELECT @xml

and I get:

  <Rows>    <content1 />    <content2 />  </Rows>  

question is: if it's possible?

  <Rows>    <content1></content1>    <content2></content2>  </Rows>  

used for html marks.

and if it's possible?

  <content1></content1>  <content2></content2>  

means without root node.

thank you very much, have a nice day.

No comments:

Post a Comment