Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Using OpenXML Part II Expand / Collapse
Author
Message
Posted Wednesday, February 1, 2006 9:16 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 8, 2013 7:23 AM
Points: 199, Visits: 136
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/rVasant/usingopenxmlpartii.asp
Post #254974
Posted Thursday, February 16, 2006 12:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 17, 2006 7:10 PM
Points: 2, Visits: 1

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

Thanks!

Post #258928
Posted Thursday, February 16, 2006 2:09 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 8, 2013 7:23 AM
Points: 199, Visits: 136
thnx.
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...
Post #258937
Posted Thursday, February 16, 2006 2:24 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 17, 2006 7:10 PM
Points: 2, Visits: 1

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?

Post #258944
Posted Thursday, February 16, 2006 5:35 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, December 31, 2008 10:25 AM
Points: 42, Visits: 3
Great 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 situations
Post #258996
Posted Thursday, February 16, 2006 10:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 23, 2007 12:50 PM
Points: 4, Visits: 1
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.


Post #259130
Posted Thursday, February 16, 2006 4:25 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 1:23 AM
Points: 363, Visits: 362

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.




Post #259246
Posted Thursday, February 16, 2006 9:48 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 8, 2013 7:23 AM
Points: 199, Visits: 136
You 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.
Post #259285
Posted Monday, April 17, 2006 3:37 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 17, 2006 3:33 PM
Points: 1, Visits: 1
Excellent article, congratulations...

Antonio Hernández
Post #273643
Posted Monday, April 17, 2006 3:55 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 1:23 AM
Points: 363, Visits: 362

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




Post #273646
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse