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.

What is de-normalization in sql database administration? Give examples?

0 Answers  

---

What do you mean by tablesample?

0 Answers  

---

write down the code for "how we delete a table without using of Drop command " ?

7 Answers   CarrizalSoft Technologies, Sonata,

---

What is update_statistics command?

0 Answers  

---

What is use of except clause?

0 Answers  

---

Which event (check constraints, foreign key, rule, trigger, primary key check) will be performed last for an integrity check?

0 Answers  

---

can a table be moved to different filegroup? : Sql server administration

0 Answers  

---

What is difference between index and primary key?

0 Answers  

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

What is clustered vs nonclustered index?

0 Answers  

---

Is it important for a database administrator to understand the operating system and file access?

0 Answers  

---

What is self contained scalar sub query?

0 Answers  

---