What is trigger ?
Answers were Sorted based on User's Feedback
Answer / ramesh tankala
Trigeer is like stored procedure which executes
automatically .
Trigger is User defined data integrity
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / piyush
Triggers are those procedures written in PL/SQL that fire whenever one of the following operation occur, DML statements on a particular schema object, DDL statements issued within a schema or database, user log on or log off events, server errors, database startup, or instance shutdown.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / indu bala
trigger is any event which is raised automatically by
database server after any instruction like
update,delete,insert is performed
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / kalyana chakravarthy maddipati
A trigger is a stored procedure fires implicitly when ever a DML(Insert, update & Delete) occurs. It is stored at server side. Its compiled and no need to compile and execute always.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / ramya
Trigger is a server-side progrm used for events(user
actions-click,key press etc..)
| Is This Answer Correct ? | 3 Yes | 3 No |
Answer / abdulla
Trigger is Limited form stored procedure associated with tables.
| Is This Answer Correct ? | 0 Yes | 2 No |
How can we improve performance by using SQL Server profiler?
What is collation?
According to you what goes into making the best database administrator? : sql server database administration
What does normalization do to data?
how to find number of columns in a table in sql server 2000 and 2005 also
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
What is a NOLOCK?
Write an sql query for deleting duplicate rows?
Do you know hot add cpu in sql server 2008?
HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE
What will happen when a Rollback statement is executed inside a trigger?
1 Answers Flextronics, Hexaware,
Tell me what are the advantages of using stored procedures?
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)