Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kiran
Trigger is a special type of stored procedure which is
implicitely executed when an insert , update or delete
happens on the data.
We dnt have to call trigger explicitely.
For applying some business rules we can fire trigger at
specific type.
Suppose i want a log when user inserts data on a particular
table i can use trigger.
2 types of trigger
1) DML Trigger - Applies on data -
- Instead of and After Trigger
2)DDL Trigger - Applies on database structure - on table or
database - these triggers came with sql server 2005.
Before sql server 2005 we were having only DML Triggers.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
How to process query result in pl/sql?
What is snowflake sql?
what is difference between delete and truncate commands? : Sql dba
What is the difference between sql, mysql and sql server?
What are the two types of exceptions in pl/sql?
What is a database? Explain
How to disable a trigger name update_salary?
Can I call a procedure inside a function?
What do you understand by pl/sql cursors?
Explain the methods used to protect source code of pl/sql.
What is t sql in sql server?
What is a sql select statement?
what is the syntax used for partition in tsql? : Transact sql
Is mariadb nosql?
Define join and name different types of joins?
