Unbelievable, 98% of right answers! I think it's the record on ssc.

Next, I will submit the following question:

What color was the Napoleon's WHITE horse?

😛

Your script replace 5 consecutive digits with 2 stars.

Here an optimized version.

declare @substr varchar(50)--substring of input string in while loop

declare @index int--index of number in the substring

set @substr = '1234567890abc89900123456abcde'

while...

Koen Verbeeck (1/8/2013)

---

Not sure what this question tries to teach us.

I spend 5 minutes looking for a mistake, only to finally decide there wasn't one, all joins seemed legit. I...

I prefer ISNULL, the cast is done to the first argument.

I use it e.g. with numeric type ISNULL(int_null,0). But, I should remember that with string ISNULL may be dangerous as...

okbangas (1/4/2013)

---

Let me quote myself, NULL is treated just like any other value in a unique constraint. It is the combination of values that has to be unique. It is...

Hi Steve and...

+1

Toreador (12/24/2012)

---

That required rather more brain cells than I was expecting to need on Christmas Eve :hehe:

Glad to see that option 5 really should be correct, I'd started to think...

Koen Verbeeck (12/20/2012)

---

Easy question. I didn't even had to check to 3rd query, because the second one gave (NULL,0) and there was only one answer in the list with that...

Hugo Kornelis (12/12/2012)

---

As happens more often with a Question of the Day: Good idea, but badly executed.

If you exactly follow the instructions, executing the 'alter proc' script after making the...

OK, I get it wrong, but I understood that the author does not know the "ON CASCADE" options.

The profiler shows Read 0

This is the most wrong and useless qotd in the history of ssc.

Easy question, but answer really wrong!

The DEFAULT is used only if no value is specified for the column or DEFAULT VALUES keyword.

-- default is triggered

create table #b (a datetime default...

+1 🙁

I think it depends on "inaccuracy in the floating point represtentation" as said Hugo.

STR convert any number to float.

Here the script to force the right round (a double cast to...