We need to add a Constraint to one of our tables which will not allow a <NULL> to a data column based on the value of a [seq_num] because we want to start using this going forward...thus wanting to specify a [seq_num] to enforce going forward.
Can anyone tell me the exact Syntax to do so? Just want to make sure we get this right with all the Constraint options and what not.
And maybe site some good web references for CONSTRAINT Syntax.
Thanks in advance for your help.