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

Popular posts from this blog

matlab - Deleting rows with specific rules -

jquery - How would i go about shortening this code? And to cancel the previous click on click of new section? -