In the short time I have been involved with the QotD I am amazed at discussions that go on over sometimes simple SQL examples. I guess I just looked...

Good question. I had to reference BOL to get the answer. Learned about STR. Thanks.

Good question. Just started using COALESCE fairly recently so it was a good exercise. Spotted the quoted NULL but it is a little tricky away from the COALESCE...

Thanks for the question.

Great Monday morning question. Thanks.

Thanks for the easy question to end the week on a high note!

That is exactly what the seed value is. The first value planted in the column to initialize it. To rollback to the seed value would be to...

Nice easy question. Thanks.

Nice question. Thanks.

Thanks.

Great question. Thanks.

Probably a better QotD is: How did 53% get the answer 2,error? :hehe:

bitbucket-25253 (10/5/2012)

Hugo Kornelis (10/5/2012)

If points are that important for you, you can have one of mine. Heck, you can have all of mine. Last time I...

Another confusing QotD! The answer is definitely 2,0. That is the results from the "selects". The "insert" errors out. It is very straight-forward.

Thanks for the easy one today!