What is a trigger?
Answers were Sorted based on User's Feedback
Answer / guest
Triggers are basically used to implement business rules.
Triggers is also similar to stored procedures. The
difference is that it can be activated when data is added or
edited or deleted from a table in a database.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / hari
Trigger is a special kind of storedprocedure automatically
executed when DML Operations done.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / kumar
In simpler words, triggers act BEHIND-THE-SCENE once they
are created.They are extremely powerful feature of SQL
Server but not exploited fully to the extent they could be..
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / mukesh kumar srivastava
A trigger is a special kind of stored procedure that responds to specific events. There are two kinds of
triggers: Data Definition Language (DDL) Triggers and Data Manipulation Language (DML) Triggers.
| Is This Answer Correct ? | 1 Yes | 0 No |
Security Question- SQL DBA exparts, need your help...
What is the cartesian product of the table?
Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.
1 01 101 01010
what types of replication are supported in sql server? : Sql server database administration
What is the purpose of self join?
Can we insert data if clustered index is disabled?
what is Full Text Search ?
Can we create clustered index on composite key?
difference between function and procedure
3 Answers Cognizant, HCL, TCS, Theorem,
Distinguish between commit and rollback?
what are isolation levels? : Sql server database administration
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)