Data Integrity for multiple columns

• bp

  SSCarpal Tunnel

  Points: 4656

  More actions

  March 11, 2003 at 12:02 pm

  #105630

  How do I validate values of a table for two columns?

  for example, I have an employee table with a start date and an end date.

  how do I make sure that the start date is always equal or greater than end date when inserting and updating into that table?

  Edited by - bp on 03/11/2003 12:09:21 PM

• mromm

  SSCarpal Tunnel

  Points: 4301

  More actions

  March 11, 2003 at 12:31 pm

  #450824

  Example:

  create table table_name

  (a datetime

  ,b datetime

  ,CONSTRAINT constraint_name CHECK ( a > b )

  )