Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
diwakar_m
Starting Member
19 Posts |
 Posted - 2008-07-02 : 07:20:15
|
| Hi,I have a column with NULLS. How do i impose Unique key constraint on the column? Is there a way to ignore the existing data and create the constraint?Please shed light on this.Thanks in advance. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-02 : 08:18:15
|
| Unique key only allows 1 null value. |
 |
|
|
diwakar_m
Starting Member
19 Posts |
Posted - 2008-07-02 : 08:22:37
|
| i know that unique key allows atmost one NULL value. But here in my case, i have some 100 records, out of which, some 10 rows have NULL values. Will it still be possible to enforce the Unique key constraint someway or the other? |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-02 : 08:39:34
|
| NO. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
diwakar_m
Starting Member
19 Posts |
Posted - 2008-07-07 : 03:16:15
|
| Thanks a lot.Hope it will solve my problem.Apologize for the late reply. |
|
|
|
|
|
|
Unique key on NULLABLE column?