InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 01:19:52 GMT20http://www.sqlservercentral.com/Forums/Topic254974-227-1.aspx<P>Muthukkalavalli,</P><P>What you are probably after is the SQLXMLBulkLoad tool, available as a separate download. There's a How-to article at <A href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_6bos.asp">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlxml3/htm/bulkload_6bos.asp</A> and several other resources at other pages. Search for SQLXMLBulkLoad.</P><P> </P><P>Good luck</P>Mon, 17 Apr 2006 15:55:00 GMTSDMhttp://www.sqlservercentral.com/Forums/Topic254974-227-1.aspxExcellent article, congratulations...Antonio HernándezMon, 17 Apr 2006 15:37:00 GMTAntonio Hernandezhttp://www.sqlservercentral.com/Forums/Topic254974-227-1.aspxYou can store your XML data into your database tables by defining a column of VARCHAR type. You use OPENXML if you want to query your XML data.Thu, 16 Feb 2006 21:48:00 GMTVasant Rajhttp://www.sqlservercentral.com/Forums/Topic254974-227-1.aspx<P>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?</P><P>Good tip.</P>Thu, 16 Feb 2006 16:25:00 GMTSDMhttp://www.sqlservercentral.com/Forums/Topic254974-227-1.aspx<FONT color=#00008b>I Need uploading an XML file to SQL Server... The scipt should use MS SQL Server Bulk import capability (OpenXML)...How can i do this.</FONT>Thu, 16 Feb 2006 10:45:00 GMTMuthukkalavallihttp://www.sqlservercentral.com/Forums/Topic254974-227-1.aspxGreat idea!! I hadn't thought to try this. I wish i had read this a couple years back. It would really have been helpful in a few situationsThu, 16 Feb 2006 05:35:00 GMTSpunky-175138http://www.sqlservercentral.com/Forums/Topic254974-227-1.aspx<P>I actually tried this in a .NET Web Application before. I want to insert data in one database call from the a web application.</P><P>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.</P><P>What way do you use OpenXML?</P>Thu, 16 Feb 2006 02:24:00 GMTDaniel Fabiahttp://www.sqlservercentral.com/Forums/Topic254974-227-1.aspxthnx.I have not tried this in a web application...but i think it will work the same way... coz this will technique will be useful if you are calling sp's from one another...Thu, 16 Feb 2006 02:09:00 GMTVasant Rajhttp://www.sqlservercentral.com/Forums/Topic254974-227-1.aspx<P>Great article. Have you tried this in real world application especially in web application.</P><P>Thanks!</P>Thu, 16 Feb 2006 00:22:00 GMTDaniel Fabiahttp://www.sqlservercentral.com/Forums/Topic254974-227-1.aspxComments posted to this topic are about the content posted at <A HREF="http://www.sqlservercentral.com/columnists/rVasant/usingopenxmlpartii.asp">http://www.sqlservercentral.com/columnists/rVasant/usingopenxmlpartii.asp</A>Wed, 01 Feb 2006 09:16:00 GMTVasant Raj