3
Reply

Can a Unique key accept more than one Null Value ?

Abhishek Kumar

Abhishek Kumar

10y
1.4k
0
Reply
    Yes, Unique Key can be accepted more than one NULL value. Create NONCLUSTERED UNIQUE Index on the Column with WHERE Filter Column_Name is not NULL.
    No. Only one Null is allowed for unique key constraint.
    Only One Null Value