Cross Apply & Outer Apply in SQL Server
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...
~-~~-~~~-~~-~