Post reply

Generating a doctype declaration with for xml explicit

  • March 9, 2007 at 9:08 pm

    #177115

    Is there a way to generate a doctype declaration in FOR XML EXPLICIT query?

  • March 12, 2007 at 8:00 am

    This was removed by the editor as SPAM

  • March 12, 2007 at 8:51 am

    #694403

    ..maybe something like this :

    create procedure test as

    begin

    select top 10 *

    from mytable

    for xml explicit

    end

     

    Cheers

    R

  • March 14, 2007 at 7:38 am

    #694938

    Actually I know how to generate the xml explicit file, but it starts with the root element. I need a file that with the following preceding the root element.

    I know I can prepend it to the xml string that comes from the xml explicit query, but was wondering if there was a way to specify it as part of the query.

Viewing 4 posts - 1 through 3 (of 3 total)

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