I get it right because of excluding the wrong choices.

Koen (da-zero)

And what if your company or your client uses an older version of SQL Server (there are still some SQL 2000 or older out there. SQL Server 2005 is...

I get it wrong, because I don't want waste...

Thank you! I learned something new and I'll take care of this for database maintenance.

😉

Koen (da-zero) (1/6/2011)

---

toddasd (1/6/2011)

---

Is it considered cheating that I went to the BOL before answering the question and read "If two or more rows tie for a rank, each tied...

Easy question, when the luck helps.

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...