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 sql sandbox in sql server?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
Can I disable or restrict ssrs export formats (rendering formats)?
how to overcome kernel isssues
What Is Rdbms?
What is subquery explain with example?
Can I use sql azure as a backup with log shipping or database mirroring?
Do you know how to send email from database?
What is the use of nvl work?
Tell me about pre-defined functions of sql?
Please explain go command in sql server?
How to set database to be single_user in ms sql server?
What are the different normalization forms?
How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?
What is dirty read?
