How to Insert Multiple Values into Multiple Tables in a Single Statement? – Interview Question of the Week #290


 

Question: How to Insert Multiple Values into Multiple Tables in a Single Statement?

Answer: One of the most popular questions, I often receive from my client  Comprehensive Database Performance Health Check. I often see people implementing trigger for this scenario. I personally do not like triggers at all. My goal in my career is to build trigger-less systems. Anything you can do with triggers you can also do it without triggers just by properly architecting your system and also wrapping various logic in a single logic.

Today we will learn how we can insert Multiple Values into Multiple Tables in a Single