Presentation Materials: The APPLY Operator

2013-11-03 - Presentations

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 used. After attending you will be able to write your own queries that utilize this powerful SQL Server only extension to the SQL Standard. You will also see how some queries might be re-written without it. Finally, the closing real world examples show queries that you can take home and immediately use in your own environment.

Prerequisites

This is a 100 level No-Slide-Demo-Only talk. To get the most out of it you should feel comfortable using the INSERT, UPDATE and DELETE statements and write simple join queries.

Downloads

Categories: Presentations

Leave a Reply