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

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

Home > .NET > SQL

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

✍: Guest

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, 7333👍, 0💬

What is the purpose of Replication
What is the purpose of Replication ? Replication is way of keeping data synchronized in multiple databases. SQL server replication has two important aspects publisher and subscriber. Publisher Database server that makes data available for replication is called as Publisher. Subscriber Database Serve... 2007-10-25, 6810👍, 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, 5984👍, 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, 5749👍, 0💬

What is DBCC
What is DBCC? DBCC (Database Consistency Checker Commands) is used to check logical and physical consistency of database structure.DBCC statements can fix and detect problems.They are grouped in to four categories Maintenance commands like DBCC DBREINDEX , DBCC DBREPAR etc , they are mainly used for... 2007-10-25, 5609👍, 0💬

Explain in short all types of diagrams in UML
How many types of diagrams are there in UML ? There are nine types of diagrams in UML : Use case diagram: They describe "WHAT" of a system rather than "HOW" the system does it.They are used to identify the primary elements and processes that form the system. The primary elements are termed as "actor... 2007-10-26, 5589👍, 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, 5393👍, 0💬

What are the different types of replication supported by SQL SERVER
What are the different types of replication supported by SQL SERVER ? There are three types of replication supported by SQL SERVER Snapshot Replication. Snapshot Replication takes snapshot of one database and moves it to the other database. After initial load data can be refreshed periodically. The ... 2007-10-25, 5285👍, 0💬

What is Modeling and why UML ?
What are advantages of using UML? As the name suggest UNIFIED MODELING LANGUAGE. Modelling has been around for years, not only in software field but also in other trades like civil, mechanical etc. Example in civil engineering drawing the main architecture built of diagram is a model by itself. Mode... 2007-10-26, 5183👍, 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, 5009👍, 0💬

.NET C C++ CSS DBA General HTML Java JavaScript JSP JUnit MySQL Networking Oracle Perl Perl PHP PL/SQL RSS Software QA SQL Server Struts Unix Windows XHTML XML

Home Hot About Collections Index RSS Atom Ask

Tester Developer DBA Windows JAR DLL Files Certificates RegEx Links Q&A Biotech Phones Travel FAQ Forum

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.