Multiple row insert of data in a single database call

Yesterday one my friends asked me how to insert data of an xml document in to the SQL Server 2000. He was looking for the best method to do that. And he mentioned about OpenXML to do that.

What’s the heck this OpenXML???

OPENXML is a Transact-SQL keyword that provides a rowset over in-memory XML documents. OPENXML is a rowset provider similar to a table or a view. OPENXML allows access to XML data as if it is a relational rowset by providing a rowset view of the internal representation of an XML document. The records in the rowset can be stored in database tables (similar to the rowsets provided by tables and views).



You can find more info at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_openxml_94mk.asp

Check out these links also...
Insert Data into SQL 2000 Using OpenXML & ADO.NET
Inserting XML formatted data into SQL Server 2000
Use OPENXML to Minimize SQL Server Database Calls