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

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  






Categories