We've potentially learnt two things:

(i) Question of the Day is...

Interesting question, nice explanation. Might have been worth mentioning the implicit type conversions as well.

Pity about the mistake in the answer. There isn't any implicit case...

Amusing question.

The first option makes sense (although it's wrong) as does the last (right) one.

But the two in between must be intended as a joke :w00t:....

I must remember to engage brain before commenting - I was thinking...

I looked at this before morning cofee or breakfast and decided that I couldn't be bothered to guess the answer before the code was fixed - came back at 00:30...

Book Depository is pretty good at international delivery. It's...

The Band

George Vobr (5/2/2016)

---

I'm surprised that in the BOL is stated: "Dates cannot be specified; therefore, the date part of the datetime value is not allowed." But the following script can...

Nice tidy question.

Since the time can be specified as a datetime variable whose date part is 1901-01-01 or as a string variable representing a datetime with the year part missing,...

Chad Crawford (4/29/2016)

---

Solomon Rutzky (4/29/2016)

---

TomThomson (4/28/2016)

---

Jeff Moden (4/28/2016)

---

Grant Fritchey (4/28/2016)

---

Technical question:

I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use...

Interesting question.

Is the correct answer really correct? It's rather naive. All the sp gives you is an estimate of average row size reduction and a count...

Jeff Moden (4/28/2016)

---

Grant Fritchey (4/28/2016)

---

Technical question:

I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able...

Whistle

Fresnel

BWFC (4/28/2016)

---

That was surprisingly easy for one of Andy's questions. There weren't any tricks or things that we should have inferred from the position of a comma :cool:. ...