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 |
Explain important index characteristics?
Does group by or order by come first?
How to write query to Delete the records in child table and corresponding records in parent table
if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?
What is the sql server 2000 version number?
What is the default isolation level of the sql server database?
Explain datetime2 data type in sal server 2008?
Explain what is row_number function?
Why can there be only one clustered index and not more than one?
Why truncate is ddl?
We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
What is the purpose of object explorer and its features? : sql server management studio
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)