Here is my scenario
I created a non clustered unique filtered index as below, but it doesn't work for me. That is to say, I cant create two rows with same EmployeeCode and different IsDeleted values. I want to maintain the unique filtered index on Employee code having IsDeleted
CREATE UNIQUE NONCLUSTERED INDEX [U_Nix_User_EmployeeCode] ON [dbo].[Employee]
If that is the way it works, Do I create trigger to enforce such a constraint?
Thanks in advance for any help
View Complete Post