Understanding APPLY Clause in SQL Server 2005: ASP Alliance

ASP.NET Tutorials » Understanding APPLY Clause in SQL Server 2005

Not Logged In. Login

AspAlliance
Register
Edit My Profile
Author List
Write for Us
About AspAlliance
Contact Us
Privacy Policy
Link To Us
Advertise

Subscribe
Free Newsletter
Newsletter Archive
RSS Syndication

.NET Tutorials
Learn .NET
Learn WCF
Learn WPF
Learn ASP.NET
Learn AJAX
Learn Silverlight
Learn Visual Studio
Learn ADO.NET
Learn LINQ
Learn C# (CSharp)
Learn VB.NET
Learn Web Services
Learn Controls
Learn BizTalk
Learn SharePoint
Learn Mobile
Learn SQL
Learn SQL Reporting
Learn Windows Forms
Learn XML
Learn Crystal Reports
Learn FarPoint
Learn DevExpress
Examples
ASP.NET 2.0 Examples

ASP Tutorials
Learn ASP
Learn VBScript
Learn JScript
Learn SQL
Learn XML

Software Resources
Shopping Cart Ecommerce
Charts and Dashboards

Other Resources
Learn Java
Learn Oracle
Opinion / Editorial
Crystal Reports Alliance
WPF Resources
AJAX Resources
Silverlight Resources

Free Tools
Cache Manager
SimpleCMS

Reviews
Book Reviews
Product Reviews
Expert Advice

Books
ASP.NET Developer's Cookbook
Sample Chapters
Book Reviews

Community
Developer Jobs
Resource Directory
ASP Email Lists
ASP.NET Email Lists
Whidbey Email Lists
AspAlliance Groups
SQL Email Lists
XML Email Lists
Regular Expressions
MS Communities
CodeWise Communities

Web Hosting
ASP Hosting
Dedicated Servers
FREE Hosting
Shared Hosting
Web Farm Hosting

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

page 6 of 6

by Sachin Dedhia
Feedback

Average Rating:

Views (Total / Last 10 Days): 18602/ 124

Article Contents:

In SQL Server 2005 we can apply the APPLY operator if a table-valued function needs to be invoked for each row retuned by the outer table expression.

View Entire Article

Article Feedback

Comment:
Title:
Name:
Url:	( Optional )

Please add 4 and 7 and type the answer here:

User Comments

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

Latest Resources
» Jabry - Free Asp Hosting with No Ads
» ASP.NET & ASP Web Hosting for only $4.95/mo
» ASP & ASP.NET Web Hosting for only $4.95/mo!
» Manged Windows Dedicated Servers
» Jabry - Free Asp Hosting, FTP with NO Ads

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