What is Trigger?

Answers were Sorted based on User's Feedback

What is Trigger?..

Answer / koti-khammam

Trigger is a special type of stored procedure that will
fire automatically when ever data modifications like

Is This Answer Correct ?    11 Yes 0 No

What is Trigger?..

Answer / kaushik chatterjee

A trigger is some what simillar to stored procedure. It is
written to perform a set of predefined actions when a
perticular database objecy such as tables,views are
Triggers are implicitly called and are NOT instactiated by
the user. Once written, it will be called automatically by
the DBMS engine when a UPDATE/DELETE/INSERT operation is
performed on the database object for which the trigger is
intended or written.
Triggers can be written for any one of the 3 operations
written above or all of them.

Is This Answer Correct ?    6 Yes 0 No

What is Trigger?..

Answer / pawan378

above answers are correct.
let me add some thing.

(Pre - Trigger) is a dynamic Rule that should be done before
Data modification Happens.
(Post - Trigger) is a Consequent step that should be taken
as soon as the Data Happens.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Which stored procedure will you be running to add a linked server?

1 Answers  

What is cross join in sql server joins?

0 Answers  

What is difference between Datepart() and Datename() in SqlServer?

0 Answers   Infosys,

what is the signification difference of this bit data type between sql 6.5 and later version sql server?

1 Answers  

How to read 2nd highest sal from EMP table?

5 Answers   IBM, TCS,

There is a table1 with records (1,2,3,4,5,6) and table2 with records (4,5,6,7,8,9).write a query so as to get the result as 1,2,3,4,5,6,7,8,9

12 Answers   RBS,

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

0 Answers  

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

How to find the second largest salary in the emp database and also How to find 3rd,4th and so on ........ in the emp database plz mail the answer @ mak2786@gmail.com

35 Answers   Oracle, Scend, TechInfini,

Write a sql query to get zero records from a table having n number of records?

0 Answers   TCS,

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers