Cross Apply & Outer Apply in SQL Server

Published: 15 August 2012
on channel: Pluralsight

21,240

110

View Full Course: https://www.pluralsight.com/courses/s...

Table Valued User Functions are an incredibly useful tool for SQL Server developers, but it takes a little bit of extra syntax to properly combine them with table queries. In this video excerpt from Joe Sack's course SQL Server: Transact-SQL Basic Data Retrieval you'll see how to use both CROSS APPLY and OUTER APPLY to perform queries similar to inner and outer joins. In the full course Joe covers other advanced topics such as INTERCEPT and EXCEPT, the OVER clause, and logical functions.

Visit us at:
Facebook:   / pluralsight
Twitter:   / pluralsight
Google+: https://plus.google.com/+pluralsight
LinkedIn:   / pluralsight
Instagram:   / pluralsight
Blog: http://blog.pluralsight.com/

3,500 courses unlimited and online. Start your 10-day FREE trial now: https://www.pluralsight.com/a/subscri...

Cross Apply & Outer Apply in SQL Server | Pluralsight

~-~~-~~~-~~-~
Push your limits. Expand your potential. Smarter than yesterday-
   • Help your team become smarter than ye...
~-~~-~~~-~~-~

On this page of the site you can watch the video online Cross Apply & Outer Apply in SQL Server with a duration of hours minute second in good quality, which was uploaded by the user Pluralsight 15 August 2012, share the link with friends and acquaintances, this video has already been watched 21,240 times on youtube and it was liked by 110 viewers. Enjoy your viewing!

227