Answer / pradeep

Triggers in DB are analogus to the triggers in hand
grenades.
It are reffered a stored procedure call that initiates its
action on any event occures such as insert, update or
delete query.

Answer / shalini

trigger is a block of code that constitutes a set of T-sql
statements activated to response in certain action.

Answer / praveen ch

trigger is nothing but a logic, this logic like a stored
procedure and which is uesd to represented as before
updation of table or after updation of the table

thank u

What are the purposes and advantages stored procedure?

0 Answers  

---

Tell me what is normalization? Explain different forms of normalization?

0 Answers  

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---

What Are Three Rules to Use UNION IN SQL SERVER

1 Answers  

---

What are commit and rollback in sql?

0 Answers  

---

What is a job?

3 Answers  

---

How to specify the collation for a character data type in ms sql server?

0 Answers  

---

Write a SQL query to delete a table?

0 Answers   Amdocs,

---

What is a primary index?

0 Answers  

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

1 Answers   HCL,

---

When to use Inner join & when to use subquery?

0 Answers   IBM,

---

How many partitions a clustered index has by default in sql server 2012?

0 Answers  

---