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
What is the significance of null value and why should we avoid permitting null values?
What is bookmark link in ssrs?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
Explain powershell included in sql server 2008?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is the use of partition by in sql server?
What is data block and how to define data block size?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration
What do we need queues in sql service broker?
What have included columns when we talk about sql server indexing?
What functions can a view be used to performed?
What is sql injection and why is it a problem? : sql server security
What are cursors and when they are useful?
Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?
What is meant by indexing files?
