SQL Server 針對欄位允許 null 建立唯一索引

CREATE UNIQUE NONCLUSTERED INDEX idx_table1_column1

ON table1(column1)

WHERE column1 IS NOT NULL;