.NET SQL - If we have multiple AFTER Triggers on table how can we define the sequence of the triggers

If we have multiple AFTER Triggers on table how can we define the sequence of the triggers

Q

If we have multiple AFTER Triggers on table how can we define the sequence of the triggers ?

✍: Guest

A

If a table has multiple AFTER triggers, then you can specify which trigger should be executed first and which trigger should be executed last using the stored procedure sp_settriggerorder. All the other triggers are in an undefined order which you cannot control.

2007-10-25, 6151👍, 0💬

What is BCP utility in SQL SERVER
What is BCP utility in SQL SERVER ? BCP (Bulk Copy Program) is a command line utility by which you can import and export large amounts of data in and out of SQL SERVER database. Below is a sample which shows BCP in action. 2007-10-25, 5131👍, 0💬

What is the difference between Stored Procedure (SP) and User Defined Function (UDF)?
What is the difference between Stored Procedure (SP) and User Defined Function (UDF)? Following are some major differences between a stored procedure and user defined functions: UDF can be executed using the �SELECT� clause while SP�s can not be. UDF can not be used in XML FOR clause but SP�s can b... 2007-10-25, 4834👍, 0💬

What is SQl injection
What is SQl injection ? It is a Form of attack on a database-driven Web site in which the attacker executes unauthorized SQL commands by taking advantage of insecure code on a system connected to the Internet, bypassing the firewall. SQL injection attacks are used to steal information from a databas... 2007-10-25, 4635👍, 0💬

What are the different types of triggers in SQl SERVER 2000
What are the different types of triggers in SQl SERVER 2000 ? There are two types of triggers : INSTEAD OF triggers INSTEAD OF triggers fire in place of the triggering action. For example, if an INSTEAD OF UPDATE trigger exists on the Sales table and an UPDATE statement is executed against the Sales... 2007-10-25, 4332👍, 0💬

All rights in the contents of this web site are reserved by the individual author. fyicenter.com does not guarantee the truthfulness, accuracy, or reliability of any contents.