sql server - TSQL: Scoping within a trigger -
i have insert trigger insert single rows 5 different tables(transaction a) in database. trigger update statusid on table(transaction b). have trigger on status if set 1 update 5 more tables based on information updated in transaction a, call trigger fired off status update transaction c
as transaction c in scope of original trigger fires transaction a , transaction b, there way select information inserted in transaction a transaction c below if scope_a first insert transaction a, scope_b second insert transaction a ... etc
select * scope_a.inserted
Comments
Post a Comment