I am currently not at a pc with sql server 2000 so this
may seem like a silly question but will the trigger below
work? I am trying to create a validation Trigger that is
attached to the 'Email' field in the table 'tblPatients',
which will raise an error if a user enters an
inappropriate email address.
CREATE TRIGGER uTR_ValEMail ON tblPatients
IF CONTAINS(EMail, '')
RAISERROR('Inappropriate Email entered', 16, 1)
Should I use a constraint rather than a Trigger for this
purpose and would the constraint be ...