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): 31948/ 45

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

User Comments

Title: The Apply Clause   
Name: Shailesh
Date: 2010-09-16 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: 2009-07-08 11:24:18 AM
Comment:
Excellent Explanation..
Title: The APPLY clause   
Name: Sachin Dedhia
Date: 2009-05-26 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: 2009-04-24 1:22:09 PM
Comment:
Beautifully explained
Title: "Using APPLY" MSDN article   
Name: Michael Freidgeim
Date: 2009-03-02 4:19:54 PM
Comment:
You should add reference to "Using APPLY" MSDN article http://msdn.microsoft.com/en-us/library/ms175156.aspx






Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2017 ASPAlliance.com  |  Page Processed at 2017-05-24 9:36:24 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search