By dotnetcodes
via dotnetcodes.com
Published: Feb 15 2013 / 08:27
SQL Server 2005 introduced the APPLY operator, which is very much like a join clause and which allows joining between two table expressions i.e. joining a left/outer table expression with a right/inner table expression. The difference between join and APPLY operator becomes evident when you have a table-valued expression on the right side and you want this table-valued expression to be evaluated for each row from the left table expression.
-
Bill Gates: Good Feedback Is the Key to Improvement
-
Yahoo Board to Meet Sunday to Consider $1.1B, All-Cash Deal for Tumblr
-
New FREE iOS App for Network Performance!
-
Facebook Buck and xctool: Open Source Build Tools for Android and iOS
-
Adopting ASP.NET MVC enhancements in an Existing Web Forms Project
-
Alternatives To Git Submodule: Git Subtree
Add your comment
