I agree, I learned to...

Tom.Thomson (12/30/2010)

---

Mixing column swap with quirky update in this form is perhaps interesting, but certainly not deterministic - even though there are no indexes involved so that the...

Last answer for 2010, I get it wrong.

I do not see a value for 2 points. It's only a simple swap. It behaves the same in any sqlserver release.

DECLARE @MyTable TABLE (Col1 INT,

...

I learned more from QotD of last friday: "what type of shirts does Steve Jones wear on Fridays?"

I got it right as specified on BOL: http://support.microsoft.com/kb/stevejones/us

HAVE GOOD HOLYDAYS AND HAPPY NEW YEAR!!!!!!!!!!!!

:-):-D:-P:-D:-)

Some tools (powerbuilder,qlick) replace CR and LF with space, so one line comment

in the script could alter the command.

Running the script in sql2000 I get 1,3,4 but in sql2005 +...

Hardy21 (12/23/2010)

---

@carlo: you are right.

But as per the question, we should give answer for the question: What will you get executing this T-SQL code in Query Analizer (SQL2K) or...

It's not a bug: CR is carriage return, so the line is the same.

The line 2 is not printed beacuse the print command is joined to the commented line.

So, change...

volter_ddun-856145 (12/23/2010)

---

first thing it can't insert null value in to Table1 AND after running that query in sqlserver i didn't get result as mentioned Correct answer.

Correct answer: 7 rows...

da-zero (12/21/2010)

---

I'm confused: the correct answer is the row that is returned "most of the time"?

If yes, then it isn't a good question, as other answers might be possible. If...

ian.grace (12/20/2010)

---

I don't understand how the first transaction could succeed given the attempt to insert the null value into the not-null field "a". Also, why is the last insert...

philip.cullingworth (12/20/2010)

---

But Answer D is

7 rows where column...

The explanation is more terrible than the question: I should read it at...

The date 21 december 2012 depends on the fact that mayan DBA are still...