7 - Inserting XML Data Using OpenXML

In the previous chapters, we’ve examined many ways of extracting XML data from Microsoft SQL Server. This process is, of course, a vital aspect of building an integration solution and one that deserves the amount of attention we have given it. However, another equally important issue is the task of inserting XML data into the database. In this chapter, we’ll turn our attention to the OpenXML function, which is used primarily to insert data from an XML document into tables in the database.

Programming Microsoft SQL Server 2000 With Xml
Programming Microsoft SQL Server(TM) 2000 with XML (Pro-Developer)
ISBN: 0735613699
EAN: 2147483647
Year: 2005
Pages: 89

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net