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

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

0 Answers   iSoft,

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

Wht is Stuff in sql ser

2 Answers  

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

Without Using Cursors , How to Select the Selected row??

3 Answers   Wipro, CarrizalSoft Technologies,

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

Can we passed multiple recordset(set of records) using a Stored Procedure

2 Answers  

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  

internal language used in sql server 2000?

2 Answers  

How to list all tables having unique constraints in any of the columns in a database.

1 Answers  

Is index a datbase objects in sql server?

2 Answers