Toreador (2/15/2013)
How long until the first complaint that the correct answer is None of the Above, because there's no such database as AdventureWorks2008 😉
Surely no one will be quite that silly?
I just assumed that the idea was to assume it was run against SQL Server 2008 with that DB installed, since it's clear from the question and the answer options that one has to assume the database exists and that seems most likely to happen with an SQLS 2008 installation.
Of course the database name would have to change to AdventureWorks2008R2 for those statements to work on my laptop, but who cares - it's not as if I would actually want to run that code anyway!
Tom