O'Reilly logo

Applied XML Programming for Microsoft® .NET by Dino Esposito

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Writing XML Data to Databases

So much for reading database contents as XML. Now let’s review the options available for persisting data to relational DBMS systems using XML representations of data. SQL Server 2000 supports three basic ways for expressing database changes using XML: OPENXML, XML bulk loading, and Updategrams.

OPENXML is a SQL Server 2000 keyword that represents a rowset provider such as a table or a view. The net effect of OPENXML is not really different from that of another relatively popular T-SQL keyword—OPENROWSET. The OPENROWSET keyword represents an alternative to accessing tables in a linked server and an ad hoc method of accessing data using any OLE DB providers. Both keywords can be referenced as if they were actual table ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required