Have you ever seen a SELECT statement joining two tables that had something like and Field = Value in the JOIN clause? Did you, like me, ask yourself, "Why did they put that in the JOIN instead of in the WHERE clause?
Read more →
Here are links to a two part article that I wrote last year forSQLTeam on the subject of Upgrading from SQL Server 7 to 2000.
Part 1: Overview
Part 2: Task List and Scripts
Read more →