trigger que?

[habesha]

does trigger fires itself?

here is the senario
I am going to create a trigger on a table that fires when the tables is updated.
but I am going to update the same table inside the trigger?
does this fire the trigger again and causing infinite firing of the trigger and updation of the table

thanks

 

[bborissov]

Check Using Nested Triggers in BOL.

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP