in SQL Server its statement level trigger. For each statement trigger is fired. There is not any solution for the scenario you are thinking of