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
Describe and explain about SQL native client?
What are the advantages of using a stored procedure?
Tell me when is the update_statistics command used?
What are the types of resultset?
What is a partitioned view?
What are the limitations/drawbacks or ssrs 2008 r2?
What number aggregate functions are accessible there in sql?
What are scheduled tasks in sql server?
What is coalesce in sql server?
What is the difference between a local and a global temporary table?
Define Joins?
Tell me what is sql profiler?
What do we have to check in database testing?
How to drop an existing stored procedure in ms sql server?
What is dbcc?
