Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best practice: EXISTS vs COL_NAME in
Message
From
13/05/2010 16:01:17
Naomi Nosonovsky
Wisconsin, United States
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Best practice: EXISTS vs COL_NAME in
Environment versions
SQL Server:
SQL Server 2005
Miscellaneous
Thread ID:
01464472
Message ID:
01464484
Views:
32
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform