The MERGE statement can synchronize imported data with base data, inserting new rows and updating existing rows, all in one go. But step beyond basics and MERGE becomes a tool that can do much, much more.

In this demo-rich session, Hugo Kornelis will present the full syntax of the MERGE statement, explain all the options, and show the possibilities. He will also demonstrate the pitfalls that you need to be aware of if you, or even someone else, uses MERGE – and show you how to solve them.

Whether you already used MERGE or not, this session will show you new ways to tackle problems that would otherwise be much harder to solve.
(no tags)
Presented by Hugo Kornelis at SQLBits XI