Re: [xml-dev] XML and SQL integration?

A lot of people I've met write their own code. This seems especially 
true when it is only necessary to transfer data between a result set / 
single table and a "tabular" XML document.

If the data structures are more deeply nested (resulting in more deeply 
nested XML documents), then people seem more likely to use the 
functionality in SQL Server itself [1] or various third-party tools [2].

-- Ron

[1] http://www.rpbourret.com/xml/ProdsXMLEnabled.htm#sqlserver
[2] http://www.rpbourret.com/xml/ProdsMiddleware.htm

Bryce K. Nielsen wrote:
> When it comes time to getting data from a SQL Server into XML (and
> visa-versa, pushing an XML document into various SQL Server tables), what
> solutions do you use? Custom programs? 3rd party ones?