May 14, 2003 at 4:34 pm
Why is XML support in SQL Server beneficial?
May 14, 2003 at 5:10 pm
Probably depends on what you're working with. OpenXML is a pretty valuable construct. I don't use For XML as much, but I do mostly desktop stuff, not web, so maybe it makes more sense there. I think it's nice to have the option. I'd like to be able to store XML docs and query them natively, there are times when that would be very handy.
Andy
May 14, 2003 at 7:21 pm
Hi there
Its common amongst enterprise developers that XML IN/OUT strings are used as parameters for class methods. As such, you see the custom wrappering of a record set (non-xml stream of data) from the dbms and then wrapping the data in a set of tags and working with the MSDOM to maniuplate it etc. It is also common to use style sheets for rendering returned data. As such, the FOR XML clauses are perfect for returning the data in a XML wrapper result set to reduce cpu cycles and work with the developed classes.
Cheers
Ck
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply