Thanks!

🙂

Maybe, you miss the UPDATE clause:

declare @mykey int

update top 1 mytable set

@mykey = mykey

where status = 0

print @mykey

I agree with Steve. C and C++ help to understand how to handle memory/cpu/io/other devices. They help to develop very good performance applications or batch processing.

In 1986, I started with...

paul.knibbs (8/3/2012)

---

All you've proved there is that a 45-character string can't ever be longer than 45 characters. Try adding PRINT @STR1 and you'll see that the string has lost the...

No, the last...

You can't rename a PERSISTED computed column, too!

Why?

I poke the wrong answer, but I learned something new.

Thanks.

😀

Good: Correct answers: 95% (70)

I never saw a qotd with 100% of correct answers.

By the way:

I often use NULLIF when 3rd party application use MAGIC VALUES instead of NULL.

e.g. 1799-12-31 stands for NULL DATETIME.

Here's a generic example to get an actual...

BIG ERROR: I answered thinking at the first 3 columns, so that Y would return without...

Is FAT32 still alive?

FAT32 is deprecated because of...

Great question.

Hugo, you are the number ONE!

Thanks.

😀

Good question!

Koen Verbeeck (4/17/2012)

---

They will all be...

I am curious to know how many developpers will use default value for "START WITH". In most cases will be a negative number.