Well it has been a little quiet here recently. I just (or it’s been two weeks now) got back from a 2 week trip to England and France. It was an amazing trip and there are a few pictures on Instagram if you are curious about what I got up to.
This is also going to be a quick post. I asked a question on Twitter last week about what happens when you have multiple triggers on a table. I got the answer (Thanks Aaron!), but figured this would be a good thing to demonstrate.
One at a time. You can control first and last but that's it - the middles will run in an arbitrary / non-deterministic order. If you have > 3 I don't know that order is going to be your biggest problem. :-) #sqlhelp
— Aaron Bertrand (@AaronBertrand) April 25, 2019
I have also been playing with Azure Data Studio and the new notebook feature, so I answered this question with a step-by-step example in a notebook. I also found that you can easily store these notebooks on GitHub so I have uploaded it to my demos repo for you to follow along.
TL;DR: Triggers execute one after the other. I demonstrated this by creating a table with three insert triggers that each waited 2 seconds and recorded the timestamp.