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

How to execute a stored procedure in ms sql server?

1250

To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

1004

how you can deploy an ssrs report?

185

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

1025

How to create a scrollable cursor with the scroll option?

1047

Explain mixed authentication mode of sql server?

1115

How to display a past time in days, hours and minutes?

1058

Can you pass expressions to stored procedure parameters?

1082

What are transactions and its controls?

1104

how to control the amount of free space in your index pages? : Sql server database administration

1085

What is log ldf?

1043

what purpose does the model database serve? : Sql server database administration

1026

Explain primary key and foreign key constraints?

1089

What are the types of stored procedures in an sql server?

1032

Explain what is dbcc?

1065