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 |
What are the steps need to be take improve the speed of a SQLDATA Server?
What is difference between cte and view?
Explain hostprotectionattribute in sql server 2005?
Can Having clause be used without Group by clause?
6 Answers CarrizalSoft Technologies, CSC, CTS,
How can I create a new template for import ? : sql server management studio
What are the disadvantages of primary key and foreign key in SQL?
What is primary key and example?
How to create an index on an existing table in ms sql server?
What are the elements of dbms?
What is coalesce in sql server?
What are the joins in sql server? : sql server database administration
sql server syntax to add "!" sign to "name" field of "employee" table in a manner that all names have the same lenght of 20 characters