Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sandeep
Triggers are also a stored procedure but it has some limits
and advantages over stored procedure.
first of all its limits. It cant accept or return values by
parameters whereas stored procedures do. It is called by
database server not by application or user.
It is generally treated as a constraint. It also make sure
the integrity of the data. We cud implement business rules
successfully by using triggers without writting a single
code in application. This is the main benifit of this
object we can change the business rule very easly from
database server when the actual business rules change that
means we dont want to edit and recompile the program soruce
code.
It will make problems in import process unless we switch
off the triggers.
There are 3 types of triggers in connection with insert,
update and delete statements
1. Before trigger
2. After Trigger
3. Instead of trigger
1. Before trigger fires before the manipulation of the data
happens by insert, update and delete statements. By using
this we cud do pre proces. ie updating other tables, pre
process of data, ..etc. After this actual manipulation
happens.
2. After triggers fires after the manipulation of the data
happens by insert, update and delete statements
3. Instead-of trigger. This trigger replaces the actual
manipulation statements. That means actual manipulation
statement wont work instead of this trigger will do the
manipulation work (statements in the trigger) by accepting
values from statement.
| Is This Answer Correct ? | 22 Yes | 2 No |
Post New Answer View All Answers
How many columns can we include on clustered index ?
what is memory-optimized nonclustered indexes
What is table constraint?
What is a Join and explain its types?
what are defaults? : Sql server database administration
Explain the working of sql privileges?
What can be used instead of trigger?
Explain transaction server isolation?
Explain important index characteristics?
What is trigger in salesforce?
What is SQL Azure Data sync?
how many type of indexing in database?
What are the new features in sql server 2016?
What is buffer cash and log cache in sql server?
Are null values the same as that of zero or a blank space?
