APPLY Operator of SQL Server 2005

Mohammed Ghouse Barq

Rate me:

3.40/5 (6 votes)

3 May 2007CPOL1 min read

40.6K

APPLY operator is a new feature in SQL Server 2005 used in FROM clause of a query. It allows you to call a function-returning TABLE for each row of your outer TABLE. We can pass outer table’s columns as function arguments.

Views

Daily Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Mohammed Ghouse Barq

Web Developer

India

Mohammed Ghouse Barq, Son of renowned urdu poet, Barq Kadapavi. A Software Engineer by proffession. I received a Masters of Computer Applications degree from University of Bangalore, Have worked in Microsoft Technologies since the DOS days.

Apart from the work I developed a knowledge base website www.geocities.com/ProgrammersVision for helping the .net community with articles, code snippets and much more. Developed and maintaining the site of a eminent urdu poet, Hazrath-e-Barq Kadapavi - www.geocities.com/BarqKadapavi

Hobbies includes not just coding but reading Deeniyat, writing Urdu Poetry with `nom de plume' as Aandaaz Kadapavi.

APPLY Operator of SQL Server 2005

Views

License

Comments and Discussions