Thursday, May 31, 2007
Tuesday, May 22, 2007
Monday, May 21, 2007
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
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."