Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / jerry joseph
Triggers are a special type of Stored procedure which
execute automatically when a triggering action like INSERT,
UPDATE or DELETE occurs.
INSTEAD OF trigger
- executes automatically in place of triggering actions like
INSERT, UPDATE or DELETE
- executes before PK, FK constrains are checked
AFTER trigger
- executes automatically after the statement that triggered
it completes
- executes after constrains are checked
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what stored procedure would you use to view lock information? : Sql server administration
What are the different types of Indexes available in SQL Server?
How to resolve the orphan use problem? : sql server security
How do I uninstall sql server 2014?
Explain multiserver query
What happens if null values are involved in bitwise operations?
What is 2nf example?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is SQL Azure Firewall?
How do you use a subquery to find records that exist in one table and do not exist in another?
What is the maximum number of instances in 32 bit and 64 bit sql server 2012?
How to find the version of sql server? : sql server database administration
What are audit control procedures?
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Is sql server 2016 free?
