在Mssql中对UNIQUE KEY约束重复空值违规

MS SQL Server does not ignore the null value and considers it as violation for the UNIQUE KEY constraint but what I know is that the UNIQUE KEY differ from the primary key where it accepts the null value.MS SQL Server does not ignore the null value an