Home Forums Programming General sql server 2000 trigger for checking duplicate email in a table RE: sql server 2000 trigger for checking duplicate email in a table

  • Hmmm - not quite sure what you're after. Do you have a 'person' table containing an e-mail field and want to maintain a separate table which contains just e-mail address (and, presumably, a foreign key back to the main 'person' table)?

    So do you therefore want to migrate your e-mail addresses away from your 'person' table? Or do you want to store them in two places for some reason?

    Please provide more detail on what you are trying to do.

    Regards

    Phil

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.