Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / kaushik chatterjee
A trigger is some what simillar to stored procedure. It is
written to perform a set of predefined actions when a
perticular database objecy such as tables,views are
DELETED,INSERTED,UPDATED.
Triggers are implicitly called and are NOT instactiated by
the user. Once written, it will be called automatically by
the DBMS engine when a UPDATE/DELETE/INSERT operation is
performed on the database object for which the trigger is
intended or written.
Triggers can be written for any one of the 3 operations
written above or all of them.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the difference between value type and reference type?
explain what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Why we use trigger in sql server with example?
what is bit datatype? : Sql server database administration
How extra digits are handled with numeric data type literals?
What is lookup override?
Does an index slow down updates on indexed columns?
How to create hyperlink from returned sql query ?
What is mscorsvw.exe - process - microsoft .net framework ngen?
What is the use of set nocount on/off statement?
How to create nested stored procedure?
What is database replication?
Explain left outer join and right outer join?
Can a trigger be created on a view?
What is the difference between a check constraint and a rule?
