带条件的唯一约束

CREATE UNIQUE NONCLUSTERED INDEX [NCI_Wms_MaterialBoxMaster_BoxCode_BoxTypeFlag]
  ON [dbo].[Wms_MaterialBoxMaster]([BoxCode] ASC)
  WHERE [BoxTypeFlag] = 3