SQL 2005 generates XML comment, array of elements

SELECT
        ‘nameValue’ AS “@name”,
        CAST(’<!– your comment –>’ AS XML),
        ‘anotherValue’ AS “another”,
        (SELECT ‘i’ AS “@name”, ‘1′ AS “@value” FOR XML PATH(’item’), TYPE),
        (SELECT ‘j’ AS “@name”, ‘2′ AS “@value” FOR XML PATH(’item’), TYPE)
FOR XML PATH(’sample’), ROOT(’root’)

output

<root>
  <sample name=”nameValue”>
  [...]

Continue reading about SQL 2005 generates XML comment, array of elements