Post reply

Declare XMLNAMESPACES

  • February 7, 2024 at 12:00 am

    #4374462

    Hello fellows,

    does anyone know how to format XMLNAMESPACE declaration so that its output is formatted specific way?

    ; WITH XMLNAMESPACES ( DEFAULT 'fsrv', 'http://www.w3.org/2001/XMLSchema-instance' as xsi, 'fsrv PositionRec.xsd' as schemalocation, '30' as Version )
    SELECT GETDATE()
    for XML PATH ('TestPath'), ROOT ('AcctFncl')

    /*******************************************************************************************************

    The output of the below script gives me namespaces declaration on the first row, but i need it in the format as such
    <AcctFncl xsi:schemaLocation="fsrv PositionRec.xsd" xmlns="fsrv" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" Version="30">

    ********************************************************************************************************/

     

  • February 8, 2024 at 12:10 am

    #4375036

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

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

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