Oh come on, points for QOTD are neither here nor there - if you can get 8 points (or whatever the number was) for knowing that you Estados Unidensians (well, I mustn't say "Yanks", must I) have fireworks on July 4th (is that scoring an indication of an anti-European bias? Proba...
These questions really are like individuals' SQL scripting styles... there are always 50 perspectives... I give you from BOL from SQL 2008 Express R2 (which many of you Gurus constantly lament us Noobs for not using): "unlike PRIMARY KEY constraints, UNIQUE constraints allow for the value ...
And the link for that http://www.sqlservercentral.com/Forums/Topic1398745-2867-1.aspx#bm1398825 And there is also this discussion on the same topic from a QOTD. http://www.sqlservercentral.com/Forums/Topic1402655-3290-1.aspx Jason...AKACirqueDeSQLeil ...