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

Post

View All

Vimal Lohani

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

By Vimal Lohani in SQL Server on Jan 10 2017

1
2.3k
1

Post Your Answer

Jan, 2017 10
Here we will use filtered unique index. Create unique nonclustered index Ix_table_column on table(column) where column is not null
- 2