For me, it came down to a guess between would it just do...

Thanks, and I hope I did not just ruin Part IV.

Would COMMIT TRAN OuterTran without the use of COMMIT TRAN InnerTran commit both transactions?

Can anybody point me to a tutorial or set of instructions on how to create a simple nightly backup for SQL server 2008 express? It is not a large...

At first I thought 3,1, but since that was not an option I came to my senses and realized that varchar does not adjust if the string is too big.

Lol, I saw the word "definitely" and immediately thought: nope, it depends. I have no substantial backing for that thought as I know nothing about computed columns, but I...

tommyh (7/6/2010)

---

UMG Developer (7/6/2010)

---

Nice question, thanks!

I'm a little surprised that so many people have gotten it correct so far, but that may be because of the copy, paste, F5 syndrome....

sadowy (6/30/2010)

---

I object.

The question presented in the email had:

mainkey int not null identity (-1,1)

but the code in the question and answer on the web site had:

mainkey int not...

lbrigham (6/28/2010)

---

In case anyone hasn't caught it yet, either question or the answer is wrong. If both the seed and increment are -1, then the answer would be -1,...

Why is the answer 'C'? Could it be possible that the query would return 'A' or 'B'?

Personally, I thought it was a trick trick question. Too easy to be that easy, but the writer was expecting me to think that so I decided it was...

The problem with questions based on syntax errors is that the person answering the question does not know if the syntax error is the issue or if the question is...

Same...

Tao Klerks (4/22/2010)

---

If you get an error on the insert, then none of the given answers is relevant - you cannot choose any of the given options, because the last...

I googled Topeka'ed it and the first item returned was a SQL server central thread. The link took me to the middle of the thread and I thought to...