Home Forums Programming XML adding an xml root attribute RE: adding an xml root attribute

  • How to add

    with xmlnamespaces( 'http://www.w3.org/TR/html4/' as "h")

    to

    SELECT getDate() as '@timestamp',

    (select name as '@name', xtype as 'data/@xtype'

    from sysobjects

    for xml path('object'), type

    )

    FOR XML PATH('root')

    so I can get