jim.powers (5/7/2008)
The question does specifically request the results from SQL Server 2005.
Yes, it does.
What will be the result when the following query is executed on SQL Server 2005?
Also, and this depends on knowing the sample databases, but AdventureWorks is one of the new sample databases for SQL 2005.
Reference:
http://blog.sqlauthority.com/2007/05/23/sql-server-2005-northwind-database-or-adventureworks-database-samples-databases/[/url]
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html