Abstract The APPLY operator was introduced with SQL Server 2005. It is an extension to the SQL Standard with the main purpose to allow us to join to a table valued function. But there is more to discover… In this talk I am going to introduce this SQL operator and show how it can be [more...]
The MERGE statement was introduced into the SQL Standard with SQL2003 and into SQL Server with version 2008. SQL Server goes far beyond the standard and implements the MERGE statement as a very powerful combination of the three statements INSERT, UPDATE and DELETE.
In this talk I am going to show five use cases that you might not have thought of before. We will also cover some issues that you must be aware of to avoid problems when using the MERGE statement.