 | CRConrad on Illustrations for Bowel resect… |
 | Mike Verhagen on foone on Twitter: I google… |
 | Attila Kovacs on [dcc32 Warning] “W1025 U… |
 | Matthijs ter Woord on File, extensions and directori… |
 | jpluimers on C13/C14 wiring diagram live/ne… |
Posted by jpluimers on 2012/11/29
Great post: SQL Server: JOIN vs IN vs EXISTS – the logical difference.
Be aware of the three valued logic when NULL gets involved.
EXIST comes closes to what you expect.
And be aware that with IN, you cannod pass one parameter containing more than 1 IN value: sql server 2005 – Passing multiple values for one SQL parameter – Stack Overflow..
–jeroen
Posted in Database Development, Development, SQL, SQL Server, SQL Server 2000, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012, SQL Server 7 | Leave a Comment »
The Wiert Corner - irregular stream of stuff 