+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...

+1

Best practise: save @@error and @@rowcount to test them later

declare @err int

,@rows int

select 1

SELECT @err = @@error, @rows = @@rowcount

if @err <> 0 or @rows = 0

...

I missed the last!

This is a PERFECT qotd!!!

You can't miss it!

:-D:-D:-D

Boh!!!!!

I do not understand what the question is about, so, how can I answer correctly?

The method 2 is incomplete or bad written.

😎

I do not like qotd too long.

Remember that SUM may return NULL, so SUM(num1)+SUM(num2) may lead to NULL:

select

sum(num1) AS S1,

sum(num2) AS S2,

sum(num1) + sum(num2) AS S3,

sum(num1 + num2) AS S4

from

...