There are mainly two type trigger 1)After trigger 2)Insted of trriger

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

Question Posted / sumesh

Answer Posted / sumesh

There are mainly two type trigger
1)After trigger
2)Insted of trriger

Baisicalt its like a stroeprocedure...

Is This Answer Correct ?

12 Yes

11 No

Please Help Members By Posting Answers For Below Questions

State the difference between union and union all?

918

What are the types of processing and explain each? : sql server analysis services, ssas

1135

How to round a numeric value to a specific precision?

1055

Where are SQL server users names and passwords are stored in sql server?

1240

How you can change the database name in SQL SERVER?

1172

To which devices can a backup be created and where should these devices be located? : sql server management studio

1022

When columns are added to existing tables, what do they initially contain?

1017

can an automatic recovery be initiated by a user? : Sql server administration

935

Explain few examples of stored procedure over triggers?

1012

What do you mean by recursive stored procedure?

934

How to insert and update data into a table with "insert" and "update" statements?

957

Explain filtered indexes?

973

What is cached report?

143

Explain the relational database management system (rdbms)?

1074

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1001