I don't like this question because 1) it has nothing to do with output parameters, 2) a 'SELECT TOP' statement does not guarantee output values without an 'ORDER BY' clause....

tabinsc (11/17/2011)

---

I didn't see anything as to what question we were supposed to answer. Luckily I guessed correctly that we were supposed to select how many rows were returned...

I really like this kind of questions 🙂

...but the question has a minor issue. When I created the QOD database with the DemoTable table and tried to rebuild the index,...

I'm sure that the part of the explanation was deleted by accident:

Because values from different data...

Another great question about SQL_VARIANT, thanks!

Another MSDN article specifies that: http://msdn.microsoft.com/en-us/library/ms173829(v=SQL.105).aspx

Nice and easy question.

I am very surprised that by now I am the only one (out of twenty) with the correct answer :blink:

Very interesting question, but 1) version-specific; 2) with wrong explanation.

I could reproduce the error only in SQL Server 2005. In SQL Server 2008 R2, the query works fine.

This situation must...

Oh, boy! I hope no one will use this code in production! :blink:

"The Default group can be moved out of the Default Pool"? The referenced BOL article says just the opposite:

Resource Governor Concepts

---

The default group is alterable but it cannot be moved...

Nice question

codebyo (10/10/2011)

---

That looks and executes right... but I can't understand why the result is not only the number 4.

After the EXCEPT, only the number 4 remains. So where does...

Nice question.

I chose the third (wrong) answer because I didn't notice the DATE data type and thought it was DATETIME 🙂

Good question, but the answer is totally wrong. The ALTER TABLE statement fails at least for two reasons (and both of these reasons are available at the link given in...

codebyo (9/13/2011)

---

I chose the four options below:

- Insert into table dbo.cuss1 generates an error msg

- Insert into table dbo.cuss2 generates an error msg

- Insert into table dbo.cuss2 does NOT generate...

Did it also return 'Could not locate entry in sysdatabases...

Hafiz Muhammad Suleman (8/24/2011)

---

already did in the same way as you telling but after that if i executes

USE test2

EXEC sp_one it execute the the the sp that is in test2...