Home Forums Programming XML adding an xml root attribute RE: adding an xml root attribute
califny
Old Hand
Points: 348
More actions
July 25, 2009 at 7:52 am
#1030148
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