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 |
What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?
What is history table in sql server?
What are transactions in sql?
What is an expensive query?
How to create new tables with "create table" statements in ms sql server?
What is the maximum rows in sql server table?
What is sql server replication? : sql server replication
What are the limitation of the Online Index Rebuild Operation?
Explain syntax for viewing trigger?
Explain the database you used in your final year project?
What are the advantages of using sql server over ms access or why should one use sql instead of ms access
What is the command used to get the version of sql server?
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)