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 DTS what are tasks available
What is inline table-value user-defined function?
Do you know what is difference between stored procedure and user defined function?
can you tell me some sites name for sql server 2000 commands with example??? plz reply soon.
What are the methods used to protect against sql injection attack?
What are types of subqueries?
How to get max 100 values from sql server
What do you mean by sql server 2005 express management tools?
Explain system views?
What does it mean if @@cursor_row returns a negative number?
What are functions
What is Data model and how to prepare a data model.?
Oracle (3253)
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)