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.

List the different types of collation sensitivities in sql server?

0 Answers  

---

1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

0 Answers   Aptroid,

---

What does COMMIT command do?

0 Answers   Amdocs,

---

Can two tables share a primary key?

0 Answers  

---

What is the difference between varchar and nvarchar types?

1 Answers  

---

WHAT OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

---

What are the different types of subquery?

0 Answers  

---

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 Answers  

---

How to assign null values to variables or columns?

0 Answers  

---

What is trigger explain with program?

0 Answers  

---

Explain an incremental backup?

0 Answers  

---

What is a field in a table?

0 Answers  

---