Nice question!

As per BOL

http://technet.microsoft.com/en-us/library/bb895144.aspx

Thanks for the easy one!

steve.jacobs (12/2/2013)

---

All,

Again, my apologies for neglecting to be more clear when asking the question. From Igor's initial comment to this question, I immediately knew I messed up and was...

I guess this thread will grow really big.

I agree with some other peers, (and with BOL), there is just one possible answer for this question, which is include ORDER BY...

That was the real Black Friday deal.

Thanks!

Koen Verbeeck (11/18/2013)

---

Please read the entire MSDN page you linked to.

The following SQL Server Database Engine features are supported in the next version of SQL Server, but will be removed...

Gazareth (11/15/2013)

---

Bob Cullen-434885 (11/15/2013)

---

Just how can LEFT return a NULL when operating on a CHAR(8)...

Good question!

I found it easy even before my coffee :-), and I guess everybody have run this anytime

SELECT MIN(ID), MAX(ID) FROM TABLE

which is pretty the same.

Thanks for the question!

Considering that it states "choose 3 answers" and there was no name "JAMES", for me was pretty clear that the author assumed a case insensitive scenario.

Thanks for the question,

Thankfully for me this was a theoretical question at an upper level, not to dig into the query plan to see what the query processor...

Nice question, it's a pity I got too engaged with the max level of permission and forgot to tick public and db_datareader...

Thanks for the easy one! Didn't even need a coffee to nail it 😀

Thanks for the question!

I personally find this link more illustrative than the provided one.

http://technet.microsoft.com/en-us/library/ms189336(v=sql.105).aspx

Thanks for the question!

It might be good also to point that table variables are not affected either by transaction rollbacks.

As per BOL

Because table variables have limited scope and are...

Nice and easy, thanks for the question!