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 do we need queues in sql service broker?

0 Answers  

---

Explain relational data?

0 Answers  

---

Do you know what is a trace frag? Where do we use it?

0 Answers  

---

What are the different methods available under sqlcommand class to access the data?

0 Answers   UGC Corporation,

---

What is in place upgrade in sql server?

0 Answers  

---

what are cursors? : Sql server database administration

0 Answers  

---

What are the basic features of a trigger in ms sql server?

0 Answers  

---

where the connection string store in the database

0 Answers   HCL, Wipro,

---

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

---

What are user defined datatypes and when you should go for them?

1 Answers  

---

what are the critical issues you have resloved in your company

0 Answers   Wipro,

---

Why should you use or avoid select * statements?

0 Answers  

---