1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

When multiple after triggers are attached to sql table, how to control the order of execution?

Question Posted / nitin yadav


When multiple after triggers are attached to sql table, how to control the order of execution?..

Answer / Priyanka Prajapati

The order of execution for after triggers in SQL Server is not guaranteed and depends on various factors such as their creation order or internal system scheduling. However, you can explicitly specify an AFTER trigger as an INSTEAD OF trigger to be executed first.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How to create new databases with "create database" statements?

1 Answers  

What is the difference between char, varchar and nvarchar?

1 Answers  

How check triggers in sql server?

1 Answers  

What is the new security features added in sql server 2016? : sql server security

1 Answers  

Explain nested trigger in sql?

1 Answers  

What is the use of @@spid?

1 Answers  

What do you mean by table and field in sql?

1 Answers  

How would you retrieve Unique rows from table without using UNIQUE and DISTINCT keyword?

2 Answers   Genpact,

What triggers long term care?

1 Answers  

Can we execute a stored procedure inside a trigger?

6 Answers   BirlaSoft, CarrizalSoft Technologies, United Healthcare,

Explain what is the difference between union and union all?

1 Answers  

How to apply filtering criteria at group level with the having clause in ms sql server?

1 Answers  

For more SQL Server Interview Questions Click Here
Categories