How to make a column which accepts unique values or multiple null without using a trigger?

Vimal Lohani

786

Here we will use filtered unique index. Create unique nonclustered index Ix_table_column on table(column) where column is not null