Explain OPENXML?
This is a discussion on Explain OPENXML? within the XML and SOAP forums, part of the Web Development category; Hi guys, Can any one describe the application of OPENXML function is SQL server 2000? Thanks devarajan.V...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
07-25-2007, 07:31 AM
| |||
| |||
 Explain OPENXML? Hi guys, Can any one describe the application of OPENXML function is SQL server 2000? Thanks devarajan.V     |
| Sponsored Links |
|
07-27-2007, 09:32 AM
| |||
| |||
 Re: Explain OPENXML? Hi Devarajan.V OPENXML provides an easy way to use an XML document as a data-source for your procedures. OPENXML allows the data in XML document to be treated just like the columns and rows of your database table i.e., xml tags as columns and the value as rows. Data can be inserted / updated very quickly and efficiently without multiple trips to the database. For example, if 100 records are to inserted / updated, then the traditional SQL method is using 100 insert / update statements. This means that 100 trips are made to the database, which results in degradation of performance. Using XML, these 100 trips can be reduced to 1 trip. This increases the performance of your application. The Oxygen |
|
10-13-2007, 01:10 AM
| |||
| |||
 Re: Explain OPENXML? OPENXML provides a rowset view over an XML document. Because OPENXML is a rowset provider, OPENXML can be used in Transact-SQL statements in which rowset providers such as a table, view, or the OPENROWSET function can appear.
__________________ S.VinothkumaR Behind me is infinite power, Before me is Endless Possibility, Around me is Boundless Opportunity, Why should I fear! |
|
10-13-2007, 01:11 AM
| |||
| |||
| Re: Explain OPENXML? Syntax OPENXML(idoc int [in],rowpattern nvarchar[in],[flags byte[in]]) [WITH (SchemaDeclaration | TableName)]
__________________ S.VinothkumaR Behind me is infinite power, Before me is Endless Possibility, Around me is Boundless Opportunity, Why should I fear! |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| MTU Explain | srikumar_l | Networking & Internet Connectivity | 0 | 12-17-2007 08:51 PM |
| :confused: plz explain........ | gk_cloud | PHP Programming | 2 | 10-12-2007 03:13 AM |
| Explain why encapsulation is required? | vigneshgets | C and C++ Programming | 1 | 08-01-2007 03:10 AM |
| Can any one explain why project needed XML? | oxygen | XML and SOAP | 1 | 07-26-2007 04:27 AM |
| Can anyone explain what is XSL ? | kingmaker | XML and SOAP | 3 | 07-21-2007 03:10 AM |
All times are GMT -7. The time now is 10:54 AM.
