Answer / manikandan

1)database trigger
2)application trigger

Answer / sam katwal

There are three types of Triggers
Insert Trigger
Update Trigger
Delete Trigger
One Trigger also exists
Instead of Trigger which was introducted in SQL Server 2000

Answer / ramprakash

Instead of Triggers
After Triggers

Answer / sandeep chawdekar

there are mainily 3 types of triggers
1> dml trigger
2>instead of trigger written on only view
3>system trigger

dml trigger written on table that gets fired on dml events
like
insert or delete or update operation
that trigger may fire
1>after dml event
2> before dml event these are timings for trigger firing

instead of trigger written only on view that view is not
modifiable that also gets fired
when dml event occurs

system trigger gets fired on system event like
before log off or after log on or before shutdown
this trigger may be written on
database level
schema level

Answer / anandkumar

DDL and DML Triggers

Answer / arjun singh

INSERT TRIGGER
UPDATE TRIGGER
DELETE TRIGGER

Practice 1: Changes to data will only be allowed on tables during normal office hours of 8.45 in the morning until 5.30 in the afternoon, MONDAY through FRIDAY. A. Create a procedure called SECURE_DML that prevents the DML statement from executing outside of normal office hours, returning the message: “you may only make changes during normal office hours” b. Create a statement trigger on the PRODUCT table which calls the above procedure. c. Test it by inserting a new record in the PRODUCT table.

1 Answers   Tech Mahindra,

When the mutating error will comes? and how it will be resolved?

2 Answers  

How can use stored procedures in sql?

0 Answers  

How do I start sql profiler?

0 Answers  

write the Sql query for creating database backup?

7 Answers   TCS,

Can we rename a column in the output of sql query?

0 Answers  

In a table only one column how to update rows

5 Answers   Microsoft,

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

What is a data manipulation language?

0 Answers  

Name Salary Abc 50000 Abc 50000 xyz 20000 find the max salary using aggregate function?

2 Answers   CTS,

Can you select everything, but 1 or 2 fields, without writer's cramp?

0 Answers  

what is denormalization. : Sql dba

0 Answers