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
INSERTIONS,UPDATIONS or DELETIONS occurs on the table.

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
DELETED,INSERTED,UPDATED.
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.

Trigger
(Pre - Trigger) is a dynamic Rule that should be done before
Data modification Happens.
or
(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  






Categories