Everything you always wanted to know about MERGE
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.
Hugo Kornelis is an established SQL Server communiity expert who spends a lot of time at various conferences. He is also a blogger, technical editor of a variety of books, and Pluralsight author. He is a SQL Server MVP since 2006.
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 18 years of SQL Server experience in various roles. He has a strong database design background, but also loves to write and tune complex queries.