Trigger internal tables
hello - if we create two triggers in a database on two different tables, how does sql server handle the internal tables? since the tables that are created are named inserted and deleted, wouldn't this create a conflict the two triggers are fired at the
same time? thank you in advance...
February 23rd, 2015 8:42pm
These are temporary, memory-resident tables which are only available when the trigger fires for the session. It will not have any conflict with other sessions.
You may read in the below link:
https://msdn.microsoft.com/en-us/library/ms191300%28v=sql.100%29.aspx?f=255&MSPPError=-2147217396
Free Windows Admin Tool Kit Click here and download it now
February 23rd, 2015 9:35pm
create a conflict the two triggers are fired at the same time?
In an INSERT/UPDATE/DELETE Statement you can address always only one table, so the Triggers won't fire at the same time.
February 24th, 2015 3:26am