Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

On my server, after insert on one table, I want to update two other tables. How can I do this using trigger?

share|improve this question
what you want to update..whole table ?? specific columns ?? are you aware you have no choice for rollback if something goes wrong ?? give full information – user21546 Jan 21 '14 at 7:38
Why should he have no choice for rollback? Trigger events do get rolled back, too. – tombom Jan 21 '14 at 9:08
What did you try? – Colin 't Hart Jan 21 '14 at 9:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.