Prassad Dabbada V R (8/21/2012)

---

I thought it will conevert everything to int. As the expression eveluates from right to left so from the right first plus will return 121 (120...

Hugo Kornelis (8/20/2012)

---

EDIT 2: I also ran a quick test to prove that SQL Server does not even evaluate the * or 1 in both the COUNT and the EXISTS...

There is no correct answer. Several terms in the question were vague enough to ensure that. It's...

Had to double-check the use of IDENTITY in table variables.

Good question -- and good answer choices!

Hugo Kornelis (8/6/2012)

---

sknox (8/6/2012)

---

Hugo, I can see why you didn't want the "choose 3" text there -- for many of us it takes a question with 31 possible answers (2^5...

Jack Corbett (8/6/2012)

---

I over thought this one, and knew I was doing it, but still did it anyway. My thinking was that, while you do not have...

Of course, the real bug is this:

Char(13) is a Carriage Return, not a Line Feed. It should, therefore, move the cursor to the...

Luis Cazares (7/19/2012)

---

coldfusion244 (7/19/2012)

---

Luis Cazares (7/19/2012)

---

Why is everyone so upset about the answer? It's clear that the question is if you can restore the database without deleting the other snapshots....

bitbucket-25253 (7/19/2012)

---

Stewart "Arturius" Campbell (7/19/2012)

---

anthony.green (7/19/2012)

---

I also read it as being Yes as the question didnt specify needing to delete or not delete the other snapshots, so in theory Yes...

Sean Lange (7/17/2012)

---

Learned something today from a good question, although it was fairly easy to deduce the correct answer. Given the binary nature of computers the max number of...

Haaico (7/12/2012)

---

I hate to say it but this is another one of those questions that is not quite clear enough. Is a processor core a logical processor or a processor?

The...

+1

I...

ScottPletcher (6/25/2012)

---

Quite true. The second part is clearly false, since "When [you are] dealing with table variables, ...", you cannot define...

ScottPletcher (6/25/2012)

---

"A Table Variable can have primary keys and indexes defined." I don't see the word "you" in there. Can indexes be defined on a table variable? Well, they can...

Gazareth (6/22/2012)

---

Nice question, thanks.

I'd like to start a quick poll: who's updated the most rows in a live table accidentally by not including a where clause in their update statement?

(Doesn't...