Thursday, June 3, 2010

NULL values in Unique keys

Recently I posted a post at SQLTeam.com

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=145497

asking about NULL values in Unique keys.

Cleary BOL states

One of the differences between a primary key constraint and a unique key constraint is that null values are allowed in a column with a unique constraint.

But it never states how many NULL values it allows.
Just if you read at my above post at SQLTeam.com you will get nowhere.
Man talk about confusion Microsoft as usual is leading the way.

No comments:

Post a Comment