Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kamal.A
Yak Posting Veteran
70 Posts |
 Posted - 2008-11-29 : 09:46:24
|
| HiWhen we will use the sp_xml_preparedocument and insert the recods to table? What is the use and performance other than default insert?Kindly give me some explanation for this.Kamal. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-29 : 11:28:40
|
| sp_xmlpreparedocument is used for preparing xml document before parsing by obtaining document handle and its used for extracting data from xml. Its used along with OPENXML. See the detailed description and example in books onlinehttp://msdn.microsoft.com/en-us/library/aa276847(SQL.80).aspx |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-29 : 15:24:57
|
In SQL Server 2005, you do not need those functions anymore.SQL Server 2005 has a built-in XML datatype along with methods to extract data from XML source.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Reg. sp_xml_preparedocument