yangli-1128

在sqlserver可空列中创建唯一约束,但是允许多个null值

https://blog.csdn.net/mynameisfish/article/details/84562713



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



标签: sqlserver
上一篇 下一篇
评论
©yangli-1128 | Powered by LOFTER