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.

I hav 10 records only one column 1,2,3,4,5......10 now am writing query select max(column name) Then What is The Output

9 Answers   Brigade, Wipro,

---

what is a deadlock? : Sql server database administration

0 Answers  

---

Explain some stored procedure creating best practices or guidelines?

0 Answers  

---

how to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,

---

What is difference between rollback immediate and with no_wait during alter database?

0 Answers  

---

What is a partition key?

0 Answers  

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

0 Answers   HCL,

---

What happens if you are trying to access a schema not owned by you?

0 Answers  

---

Security Question- SQL DBA exparts, need your help...

3 Answers  

---

What is a function? Give some example?

3 Answers  

---

What is a Stored Procedure?

8 Answers  

---

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---