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

what are the authentication modes in sql server? : Sql dba

0 Answers  

Can you upgrade sql express to full sql?

0 Answers  

i have a customer table. trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output. trans_id trans_amt debit_credit_indicator i want get highest credit amount and lowest credit amount and highest debit amount and lowest debit amount for each trans_id.

2 Answers   Oracle,

What is java sql driver?

0 Answers  

describe transaction-safe table types in mysql : sql dba

0 Answers  

Is join and inner join the same?

0 Answers  

What is the order of sql select?

0 Answers  

What is the difference between delete, truncate and drop command?

0 Answers  

How to use boolean type in select statement?

0 Answers  

a procedure one in two out parameters i am waiting it in a sql query can i get the output

1 Answers  

What is partition by in sql?

0 Answers  

What are inbuilt functions in sql?

0 Answers