Best practice: EXISTS vs COL_NAME in

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Best practice: EXISTS vs COL_NAME in

Message

13/05/2010 16:01:17

13/05/2010 15:57:02

Information générale

Forum:

Microsoft SQL Server

Catégorie:

Syntaxe SQL

Titre:

Versions des environnements

SQL Server:

SQL Server 2005

Divers

Thread ID:

01464472

Message ID:

01464484

Vues:

>>BTW, please check this blog
>>
>>http://sqlservercode.blogspot.com/2007/04/you-should-never-use-in-in-sql-to-join.html
>>
>>so you may stop using IN (..) syntax after reading it. I know I did switched long enough to NOT EXISTS /EXISTS .
>
>Thanks.

Glad to help. BTW, it is called a subquery, not derived table.

If it's not broken, fix it until it is.

My Blog