Post reply

Triggers

  • May 16, 2008 at 3:18 pm

    #190621

    Hi All,

    Can we have a trigger for two tables..? If so How to query it...

    Thanks

    Soma

  • May 16, 2008 at 5:02 pm

    #816775

    Can you be more specific? For example, do you want the triggers to fire only when the same thing happens to two tables at the same time? Or, do you want to make one trigger that responds to things that happen to two tables (not possible)? Or, do you have something else in mind?

  • May 16, 2008 at 5:11 pm

    #816778

    Let me put the question like this...

    Can we generate a trigger for two tables? if so what is the query to generate a trigger for two tables employee table and department table with employee having department no.

    Is it a possible scenario

  • May 16, 2008 at 5:23 pm

    #816784

    Sounds like you want cascading triggers or Cascading Referential Integrity Constraints. I don't have an example handy. Look at BOL and see if they really are what you want.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply