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.

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.

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.

In what version of sql server were synonyms released?

0 Answers  

---

What happens if null values are involved in datetime operations?

0 Answers  

---

An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).

9 Answers   ADP,

---

How extra digits are handled with numeric data type literals?

0 Answers  

---

Explain what are the restrictions that views have to follow? : SQL Server Architecture

0 Answers  

---

What are primary keys and foreign keys?

4 Answers  

---

How do I find sql server instance name?

0 Answers  

---

What are the different editions available in sql server 2000?

0 Answers  

---

How to send email from database?

0 Answers  

---

Which are the new data types introduced in sql server 2008?

0 Answers  

---

What language is sql server written in?

0 Answers  

---

How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  

---