How to allow nulls in unique fields

added by DotNetKicks
12/28/2016 3:36:03 PM

1 Kicks, 341 Views

Unique fields in SQL Server are created using unique constraints or unique indexes, furthermore, each unique constraint uses a unique index. Regardless of using unique constraint or unique index, the field can accept null values, however the uniqueness will result in only accepting a single row with null value.