Sunday, 8 February 2015

How to accept multiple nulls for unique key column in sql server

CREATE UNIQUE NONCLUSTERED INDEX idx_yourcolumn_notnull
ON YourTable(yourcolumn)
WHERE yourcolumn IS NOT NULL;

No comments:

Post a Comment