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 do you mean by data manipulation language?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What programming language would you use to create embedded functions in ssrs?
Do you know exporting and importing utility?
What happens if null values are involved in bitwise operations?
What is Dependency Injection and provide example?
Why would you call update statistics?
What is the difference between dropping a database and taking a database offline?
Explain can SSRS reports Cache results?
How can we get count of the number of records in a table?
What is for xml in sql server?
What are the restraints imposed on the table design by a merge replication?
Explain nested stored procedure. Syntax and an example for create nested stored procedure?
What are the advantages of using cte?
