Help me with adding a constraint to a table.

• mw_sql_developer

  SSCoach

  Points: 19445

  More actions

  September 16, 2015 at 12:08 pm

  #321256

  Select MemberNbr, EligYear,EligMonth, count(*) FROM [MemberMonth]

  GROUP BY MemberNbr, EligYear,EligMonth HAVING COUNT(*) > 1

  THIS WILL GIVE ME ZERO ROWS,,, That is GOOD which means NO DUPLICATES....

  I need to add a constraint to the table

  MEMBERMONTH to make sure no one can insert duplicate

  records.

  Can you suggest what constraint to add ?

  The fields are

  MemberNbr VARCHAR,

  EligYear INT ,

  EligMonth INT

• Kristen-173977

  SSCrazy Eights

  Points: 8687

  More actions

  September 16, 2015 at 12:13 pm

  #1827168

  UNIQUE INDEX on the three columns

  (UNIQUE CONSTRAINT comes to the same thing, I think??, in SQL Server)