I guess.. this; if the aliases are been removed in SELECT block, it gives below error on ambiguity for...

Interesting question, thank you Tom.

(even kind of knowing the output for each select statement, it tempted me to challenge self and to prove it)

it is something like this, the 123 and 100 are integers, but it is converted in to...

"RAID (redundant array of independent disks) levels 0, 1, and 5 are typically implemented with SQL Server."

Just...

Phew! Toughest question of the year.

And a Happy New Year to you all. In the New Year, wish you the best year you've ever had.May you realize your fondest dreams...

Jeff Moden (7/26/2012)

---

... SQL Server and all those things are just too big for one person to be good at all of that.

If you want an expert in SSAS,...

Fine learning... thank you for the question. (this is completely new for me) 🙂

Awesome. (this is really very interesting thing) thanks for the question.:-)

Very Nice QtoD. (the joins are finally getting stronger... 🙂 )

Actually the "default value" in the link mainly tells on the default value of the DATETIME datatype and the date value is not beyond that.

The usage of the GetDate()...

nice 🙂 thank you for the question

(though it was simple and straight question, not sure why i kept occupied myself thinking as it was a trick question... :crazy:)

nice 🙂

(..actually came to know these levels 6 years ago, I used (NOLOCK) in the select statements on DWH queries and was wondering rather than typing nolock for each table...

Nice, back to basics.

I don't use this in real-time scenario at all, but few weeks ago I was just looking at them just to refresh my memory. Infact I used...

I agree...

Nils Gustav Stråbø (11/13/2012)

---

Thanks for the question.

Got it wrong because I missed the last INSERT statement after the WHILE LOOP.

If the intention was to test the knowledge of nested transactions...