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 |
|
akki1563
Starting Member
10 Posts |
 Posted - 2012-02-28 : 09:01:29
|
| Hi,I am new to sql server 2008. I need a store procedure which does bulk insert new records and update the old records in the database.I achieved bulk insert using xmldoc. I have converted the List of object into xmldoc and passing xmldoc as parameter to the store procedure.But, I need to insert only new records and update old records.How to achieve it.Is my approach right or should I need to follow any other approach. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
|
|
|
Bulk Insert and Bulk Update in single SP