Monday, May 21, 2007

SQL Server: JOIN vs IN vs EXISTS - the logical difference

SQL Server: JOIN vs IN vs EXISTS - the logical difference:
There is a common misconception that IN behaves equaliy to EXISTS or JOIN in terms of returned results.
This is simply not true. To see why not, let's review what each statement does.

IN: Returns true if a specified value matches any value in a subquery or a list.
Exists: Returns true if a subquery contains any rows.
Join: Joins 2 resultsets on the joining column.

Thursday, May 10, 2007

Origami to the max

foldschool - cardboard furniture: "foldschool is a collection of free cardboard furniture for kids, handmade by you. The downloadable patterns can be printed out with any printer. Follow the instructions and assemble a stable piece of furniture."