Great question to end the week! Thanks.

Thanks for the clear question and explanation! Learned something about IDENTITY columns.

Totally bogus QotD!! If you follow the directions you cannot get the results. If you stray from the directions then you are making up your own QotD. ...

Good question. Too hard for me.

Thanks for the great Monday morning question.

Thanks, great question.

Hugo Kornelis (12/6/2012)

---

I picked the right answer, but only after thinking about it for a long time - go with Books Online, or go with common sense. So I am...

Thanks for the easy point. I needed it this week!

Thanks for the question.

Toreador (12/5/2012)

---

Shame about the endless complaints about the semi-colon (does nobody ever read the thread before adding to it?)

The easy way to have avoided confusion as to whether the syntax...

BLAH! Why can't I ever read question writers minds?

Too often the surprise questions leave me sitting there going... did he mean for the ; to throw the error or...

hakim.ali (12/4/2012)

---

Isn't the very point of posting on a forum so that you can share your thoughts with others?...

Dont' know what everyone else got but on SS 2008 I got:

Msg 102, Level 15, State 1, Line 5

Incorrect syntax near ';'.

Looks like another fine QotD!

Thanks. !?

Was very cautious in answering this QotD because I knew there were some land mines in it. Thanks, it made me review very closely the BOL on referential integrity.