Hi, i need a GUID at row level in my table (name column RowGuid)
datatype is uniqueIdentifier.
Do I need also state it as a UNIQUE KEY (alternate key)?
Ex:
RowGuid uniqueIdentifier UNIQUE KEY
Thanks
views:
18answers:
1
+1
A:
just one thing you have to remember : Unique Key column allows only one row having null value.
I dont think because GUID are unique.
Pranay Rana
2010-07-30 10:52:12
thanks! once again
GIbboK
2010-07-30 11:10:33
unless, of course, you use a **filtered index** (available in SQL Server 2008) which only looks at the non-null values - then the number of NULL values becomes irrelevant...
marc_s
2010-07-30 11:48:02