Great article. Have you tried this in real world application especially in web application.

Thanks!

I actually tried this in a .NET Web Application before. I want to insert data in one database call from the a web application.

My big problem with this is the OutOfMemory error/exception when assigning the XML string to a string variable. This problem occurred if the datasource is too large (50,000 thousands record, 30 columns). That string variable is suppose to be passed the stored procedure. Haven't solve this problem and I have to revert back to old way of looping and call a database insert.

What way do you use OpenXML?

Thank you.  One of those "obvious when you think about it for more than a couple of minutes" situations, but aren't they they the best sometimes?

Good tip.

Muthukkalavalli,

What you are probably after is the SQLXMLBulkLoad tool, available as a separate download.  There's a How-to article at http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_6bos.asp and several other resources at other pages.  Search for SQLXMLBulkLoad.

Good luck