Answer / guest

Triggers are basically used to implement business rules.
Triggers is also similar to stored procedures. The
difference is that it can be activated when data is added or
edited or deleted from a table in a database.

Answer / hari

Trigger is a special kind of storedprocedure automatically
executed when DML Operations done.

Answer / kumar

In simpler words, triggers act BEHIND-THE-SCENE once they
are created.They are extremely powerful feature of SQL
Server but not exploited fully to the extent they could be..

Answer / mukesh kumar srivastava

A trigger is a special kind of stored procedure that responds to specific events. There are two kinds of
triggers: Data Definition Language (DDL) Triggers and Data Manipulation Language (DML) Triggers.

Does index speed up select statements?

0 Answers  

---

How to create new tables with "create table" statements in ms sql server?

0 Answers  

---

What is clustered index

0 Answers  

---

How to connect of datebase with sql express.?

0 Answers   MCN Solutions,

---

Describe how to use linked server?

0 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

How to link up the text file to a Database table?

2 Answers   Allianz,

---

How can you stop stored procedures from recompiling?

0 Answers  

---

What is the main purpose of having conversation group?

0 Answers  

---

What do mean by xml datatype?

0 Answers  

---

How to generate create function script on an existing function?

0 Answers  

---

What are the advantages of passing name-value pairs as parameters?

0 Answers  

---