CREATE UNIQUE NonCLUSTERED INDEX [UQ_ID_CategoryName_Name, CategoryName, Name] ON TableName ( ID, CategoryName, Name)WHERe (CategoryID = 0)

CREATE UNIQUE NonCLUSTERED INDEX [UQ_ID_CategoryName_Name, CategoryName, Name] ON TableName ( ID, CategoryName, Name)WHERe (CategoryID = 0)