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 |
|
baddulas
Starting Member
11 Posts |
 Posted - 2014-03-29 : 14:38:30
|
| Hi all,Please help on the below scenario.Source - OracleTarget - SQL ServerAfter every 2 hours data is truncating from target and loading the source data.Now i don't want to lose the target data.only matched records needs to be delete from target.Which approach is best for the above scenario. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-03-31 : 18:15:59
|
| See MERGE in BOL===============================================================================“Everyone wants a better life: very few of us want to be better people.” -Alain de Botton |
 |
|
|
|
|
|
Data Truncation Issue