Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to add attributes to the root element when generating XML?
In case anyone is interested, below is a solution that is working as desired. I had to do a little messing around with the namespace reference at the very end because SQL requires the namespace while building the XML, but was adding it to more elements than just the root. DECLARE @xmlDoc...- PPettitDN
- Post #2
- Forum: Microsoft SQL Server: Programming
-
How to add attributes to the root element when generating XML?
I'm experimenting with creating PIDX XML data straight from SQL (Microsoft SQL Server 2005 - 9.00.5057.00). I'm just getting started but ran into a roadblock when trying to add an attribute to the root element. This is what I've got so far: DECLARE @xmlDoc VARCHAR(MAX) ,@declaration...- PPettitDN
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
