Understanding APPLY Clause in SQL Server 2005: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Understanding APPLY Clause in SQL Server 2005

page 1 of 6

Published: 13 Nov 2006

Abstract
In this article Sachin examines the usage of APPLY clause using SQL Server 2005 with the help of examples.

by Sachin Dedhia
Feedback

Average Rating:

Views (Total / Last 10 Days): 26916/ 87

Article Contents:

Introduction

Those who have extensively worked on database development with SQL Server 2000 would have, at some point in time, come across a shortcoming of user-defined functions. Delve further into this and you would agree too.

View Entire Article

(Page 2) »

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 6 and 7 and type the answer here:

User Comments

Title: The Apply Clause
Name: Shailesh
Date: 9/16/2010 9:51:08 AM
Comment:
The presentation is better as compared to the MSDN article.

Small and Sweet!

Thanks

Title: APPLY clause
Name: Vivek
Date: 7/8/2009 11:24:18 AM
Comment:
Excellent Explanation..

Title: The APPLY clause
Name: Sachin Dedhia
Date: 5/26/2009 4:14:26 PM
Comment:
Still cannot see why is apply clause any better than join for SQL 2005
Thanks

Title: user
Name: user
Date: 4/24/2009 1:22:09 PM
Comment:
Beautifully explained

Title: "Using APPLY" MSDN article
Name: Michael Freidgeim
Date: 3/2/2009 4:19:54 PM
Comment:
You should add reference to "Using APPLY" MSDN article http://msdn.microsoft.com/en-us/library/ms175156.aspx