Post reply

Retrieving relational data as XML Document

  • January 26, 2009 at 7:21 am

    #97137

    How can I force the empty result set to XML format, so that empty nodesdisplay.

    E.g

    select a,b

    from tableName for xml path('Some Node'), root('Some root'),elements xsinil,type

    results:

  • January 26, 2009 at 7:39 am

    #932595

    Thanks, I've got the answer already. I had to use isnull() function for this

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply