Yes,...

The title of the question has nothing to do with the trick question with the IsNULL() function and the variable length. The question only proves that IsNull is using the...

+1 Thank you for this easy one. I've been educating people about the news in SQL server 2012 and I really like this function. Not becase the possibility to concat...

L' Eomot Inversé (8/20/2013)

---

I doubt it; probably the...

+1 Learned something new today. The leaderbord has a bug, is that the reason why I am not at the top? 😀

Nice "tricky" question! Thank you!

kapil_kk (7/22/2013)

---

PRR.DB (7/22/2013)

---

If table doesn't have clustered index , there is no guarantee for order , if table having clustered index then result will display clustered index column order.

Is...

This was an easy question, but in reallity too many "developers" have missed this fact.

Easy question, as long as I ignore the fact that some instances may require case sensitivity because of the applications using the db (well... not written by me, but probably...

Nice question!

Nice question, but the right option is missing. Row locks are never escalated to page locks according to BOL.

"The Database Engine does not escalate row or key-range locks to page...

Well, this was an easy one!

You can use table variables in some type of functions, but not in all. You can't use(declare) a table variable in an inline table...

Nice question, I was only focusing on the string concatenation and not the declaration.

Nice question!

I knew it couldn't be a simple answer, but I answered based on what it should have been if it wouldn't have been the CASE difference. I don't like questions...