From what you describe, it sounds like UDF is your problem, so you'll need to post the definition of it. If it's a multi-statement table-value function (MTVF) and not an...

Nice question, I learnt something new today

L' Eomot Inversé (3/14/2013)

---

Nice question and correct answer (pity about the locale issue, though).

Unfortunately, the explanation is rather wrong - not surprising, as the BOL page on smalldatetime also gets...

kapil_kk (3/14/2013)

---

Richard Warr (3/14/2013)

---

Hugo Kornelis (3/14/2013)

---

Locale settings.

Contrary to popular belief, yyyy-mm-dd hh:mm:ss and yyyy-mm-dd are...

+1

Dineshbabu (2/21/2013)

---

Nice and easy one. Initially I overlooked the word WTH and answered the question. After seeing the explaination only i realised it was mispelled and it will act as...

opc.three (3/12/2013)

---

This one made me research some command line utilities I had not used related to Named Pipes but deprecated, i.e. should not be used but is still supported !=...

Hugo Kornelis (2/13/2013)

---

I had almost missed the different time in the returned output, as I was focusing completely on the data type. Caught is just in time!

I do not agree...

Good one

kapil_kk (3/12/2013)

---

Hi all,

Actually I read an article with a name Difference between Datetime and Datetime2 and surprised with the functioning of that so then I think of implementing that thing...

Miles Neale (3/8/2013)

---

chgn01 (3/8/2013)

---

Did I am misleading for the answer? Why so many answers are wrong?

How other members answeredCorrect answers: 55% (374)

Incorrect answers: 45% (302)

Total...

Good one

+1

Raghavendra Mudugal (2/27/2013)

---

Very interesting question, did not know until now... and I answered all correct with just mental work 🙂 and I can feel my confidence is somewhat kicking in...

ronmoses (3/1/2013)

---

Where I got tripped up was here, and I guess I'm still not sure I understand...

create proc sp1

as

select * from temp1

exec sp2

Without a BEGIN and END defining the body...