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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2006-08-31 : 06:34:07
|
| I am new to XML. I am have generated an xml file and want to update my sql table with this data, or add a new record if it doesn't exist.Could some please point me to a web site on how to do this or explain to me how.TIA |
|
|
magnetica
Starting Member
36 Posts |
Posted - 2006-08-31 : 07:46:17
|
| OK. Heres a few websites but if you are thinking of learning XML with SQL then i suggest that you buy a book..[url]http://www.stylusstudio.com/sqlxml_tutorial.html[/url][url]http://support.microsoft.com/default.aspx?scid=kb;en-us;316018[/url]Hope these help! |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-31 : 07:48:26
|
| URL tags doesn't work with semicolons. For the second link magnetica sent, subsitute spaces before and after "en-us" with semicolon.Peter LarssonHelsingborg, Sweden |
|
|
|
RyanRandall
Master Smack Fu Yak Hacker
1074 Posts |
Posted - 2006-08-31 : 07:55:21
|
| Google gives plenty of articles on importing xml files too...http://www.google.com/search?hl=en&q=%22xml+file%22+%22sql+server%22And you can use "if exists ... update ... else ... insert ..." type syntax to do the other bit.Ryan Randallwww.monsoonmalabar.com London-based IT consultancy Solutions are easy. Understanding the problem, now, that's the hard part. |
|
|
|
magnetica
Starting Member
36 Posts |
Posted - 2006-08-31 : 08:27:59
|
quote:
URL tags doesn't work with semicolons. For the second link magnetica sent, subsitute spaces before and after "en-us" with semicolon.
Oh OK. I will remember that for next time.If you think you know it all?! You know nothing! |
|
|
|
|
|
|
Using XML to update SQL table