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.

check, not null,unique

2 Answers   IBM,

---

Tell me what is the difference between locking and multi-versioning?

0 Answers  

---

What is the difference between writing data to mirrored drives versus raid5 drives

0 Answers  

---

What is difference between Triggers and store procedure?

2 Answers  

---

What will be query used to get the list of triggers in a database?

0 Answers  

---

How to create an multi-statement table-valued function?

0 Answers  

---

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

1 Answers  

---

how many types of store procedre in sqlserver 2000?

2 Answers   ATI,

---

What are the built in functions in sql server?

0 Answers  

---

What does <> symbol mean?

0 Answers  

---

How many types of TRIGGERS are there in MS SQL Server?

8 Answers   CarrizalSoft Technologies, TCS, United Healthcare,

---

Explain the truncate command? : SQL Server Architecture

0 Answers  

---