How would I create a trigger that will copy the content of one record in a Table to a different table
Posted on 2007-11-16
I want the trigger to fire only if the field named complete is = true.
But I only want it to copy it once not every time someone completes the form. This is because the data in the 2ed, table my get edited, and I donÃƒÂ¢Ã‚Â€Ã‚Â™t want the info over written every time another person marks a form complete.(true)
Is there a sample of how I would do this?
IÃƒÂ¢Ã‚Â€Ã‚Â™m using SQL server 2005.
Thanks for any help!