Can there be multiple null values in column which have unique constraint set?

Question

Anonimo · Accepted Answer

No.But there are multiple workarounds, one of it is as follow
CREATE UNIQUE INDEX indexName ON tableName(columns) INCLUDE includeColumns WHERE columnName IS NOT NULL

Anonimo · Answer

unique key constraint column allow only once null value. If we try to add another null value it shows an error as - can not insert null value.

Bridgenext

Domanda di colloquio di Bridgenext

Risposte di colloquio

Aziende seguite

Ricerche di lavoro