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 |
|
mikejohnson
Posting Yak Master
153 Posts |
 Posted - 2002-11-14 : 10:57:37
|
| I have an xml file. What I need to do is read certian xml fields and according to the fields, i need to update/edit/delete/add the corresponding information in my sql database. What is the best way of doing this? I don't know whether to just import the xml file into sql and then read the data there or read the data in the xml file and then handle it accordingly. Either way, I don't know where to start. Any help is appreciatted. One thing I would like to know is how to import xml files into sql very easy. I haven't been able to find this yet.thanxmike |
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-11-14 : 12:23:23
|
| Check out sp_xml_preparedocument in Books on Line, that should get you going.hth,JustinHave you hugged your SQL Server today? |
 |
|
|
mikejohnson
Posting Yak Master
153 Posts |
Posted - 2002-11-14 : 12:31:04
|
| Do you mean actual books online or is that a section of this site or what? If it's online can you provide a link?thanxmike |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-11-14 : 12:43:41
|
| books online (aka BOL) is the Help section that comes installed with SQL Server.... |
|
|
|
mikejohnson
Posting Yak Master
153 Posts |
Posted - 2002-11-14 : 12:58:44
|
| thanks! |
|
|
|
mikejohnson
Posting Yak Master
153 Posts |
Posted - 2002-11-14 : 14:12:46
|
| i can't seem to get into the books online. I don't know if it was installed, I'm at work... Is there any other access to it? If not, can someone copy the stored procedure you're talking about here and that way I can see it... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2002-11-14 : 14:32:38
|
| I believe BOL is available at the MS site. You will want to look there. I don't have a link to it, so you're going to have to search for it. |
|
|
|
JustinBigelow
SQL Gigolo
1157 Posts |
Posted - 2002-11-14 : 14:52:30
|
| You can download Books On Line here[url]http://www.microsoft.com/downloads/release.asp?ReleaseID=29428&area=search&ordinal=1[/url]JustinHave you hugged your SQL Server today? |
|
|
|
|
|
|
getting xml into sql