Yes, it would be nice if the explanation explained what the bitwise compound assignment operators were especially since those were the real challenge of the question. Even the link...

Only if you first set IDENTITY_INSERT to ON; the default setting for IDENTITY_INSERT is OFF. . .

Good question, Hugo!

I would change "Because of the IDENTITY attribute, no duplicate values for PersonID will occur" to "Because of the IDENTITY attribute, no duplicate values for PersonID can[/i] occur."

The...

I'm not sure what is going on but when I went to http://www.sqlservercentral.com/questions/T-SQL/68500/

and answered predicate (to the revised question), the site said:

Sorry - you were wrong

Correct answer: Operator

Explanation:...

Now it's even more confusing - the question has changed; the answer has changed from predicate to operator which I don't think is correct with the new question; and, the...