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 ...

Get Applied XML Programming for Microsoft® .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.