I expected there will be some trickery work will be there.. But it's easy and staright forward question..

Nice question and i learned about accuracy and 2012 function(DATETIMEFROMPARTS). I don't know how this accuracy will help me in production..

What I feel is Instead of assigining values to...

Nice question..

I thought smalldatetime will round off to next day only if there is 2 seconds difference and answered both will return day as 24.

One easiest way to avoid this confusion is .. don't use SELECT * INTO.

Always prefer CREATE TABLE..

After answering the question.. I thought, Dinesh u r great.. you are one among the 30%.. But after reading everyone's comments only i understood i'm in wrong side.

I read the question very carelessly. I didn't notice that variable declared without specifying length.

Hugo Kornelis (3/5/2013)

---

Normally, I either post with additional information, or do not post at all. But in this case, even though I didn't see anything I could add to the...

First time I'm seeing Hugo's post without any information.

Really interesting one.

Thanks for making me to understand that disabling a clustured index will block DML operations on underlying table.

Nice and Easy one..

Thanks to Hugo & Tom for explaining about Divide By Zero.

Danny Ocean (3/1/2013)

---

I think, this question is not well define. When you execute this code, it's execute and throw below error

Msg 217, Level 16, State 1, Procedure sp2,...

Easy one..

Remembering the basic methodology of Update.

I forget the exact term which prevents data getting updated recursively.

Interesting question.

I wonder why people thinking too complex(colation) for simple task.

Easy One..