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 do I manually uninstall an instance of sql server 2016?
1 01 101 01010
What are the types of lock supported by ?
What is the difference between function and stored procedure in sql server?
How do I find sql server instance name?
What is cached report?
Tell me what is the difference between locking and multi-versioning?
List the types of recovery model available in sql server?
How to disconnect from a sql server using mssql_close()?
what is difference between view and Dip.
How do I know if localdb is running?
what are constraints? Explain different types of constraints? : Sql server database administration
What are the pre-defined functions in the sql server?
What is the difference between a "where" clause and a "having" clause?
How to list all tables in the database using odbc_tables()?
