Prevent duplicate rows with many columns
Here's an example where a the unique constraint is part of the table creation command...

CREATE TABLE dbo.Ability_Main (
    Ability_ID SMALLINT NOT NULL,
    Ability_Text NVARCHAR (150) NOT NULL,
    Flag_Conditional BIT NOT NULL,
    Flag_Choose TINYINT NOT NULL,
    F1 BIT NOT NULL,
    F2 BIT NOT NULL,
    F3 BIT NOT NULL,
    F19 BIT NOT NULL,
    F20 BIT NOT NULL,
    CONSTRAINT UQ_AbilityMain_BitFlags
        UNIQUE (F1, F2, F3, F19, F20)
        --WITH (...) ON [FILEGROUP],
    CONSTRAINT PK_Ability_Main
        PRIMARY KEY CLUSTERED (Ability_ID ASC)
        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY];
GO


Or added after the fact, in a separate command...

ALTER TABLE dbo.Ability_Main ADD CONSTRAINT UQ_AbilityMain_BitFlags UNIQUE (F1, F2, F3, F19, F20)
--WITH (...) ON [FILEGROUP];
GO