Posted by Erland Sommarskog on 10/01/77 11:43

Shilpa (shilpa.nagavara@unisys.com) writes:
> I want to pass XML and the data in the XML should be stored in the
> tables of the database. However, I do not want to use the OpenXML
> statement. Please let me know.

Which version of SQL Server are you using? If you are on SQL 2000, and
you to insert data in the XML statement piece by piece (and not just
the XML document as such), there is no alternative to OpenXML.

On SQL 2005 you can XQuery to extract data from the XML document.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]