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.

What does it mean to invest in the index?

0 Answers  

---

1 01 101 01010

0 Answers  

---

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

---

Questions regarding Raiseerror?

1 Answers  

---

How to make a column nullable?

0 Answers  

---

What is sub query and its properties?

0 Answers  

---

How to concatenate two binary strings together?

0 Answers  

---

what changed between the previous version of sql server and the current version? : Sql server database administration

0 Answers  

---

Differences between logshipping and mirroring

1 Answers   Microsoft, Syntel,

---

What command do we use to rename a db, a table and a column?

0 Answers  

---

What is the cartesian product of table?

0 Answers  

---

What is right outer join in sql server joins?

0 Answers  

---