Answer / sathish kumar.t

Trigger is the collection of T-SQL statements, which is
activated based on certain actions. Trigger is fired, when
any of one DML statements will occur..

Answer / raji

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 / jerry joseph

Triggers are a special type of Stored procedure which
execute automatically when a triggering action like INSERT,
UPDATE or DELETE occurs.

INSTEAD OF trigger
- executes automatically in place of triggering actions like
INSERT, UPDATE or DELETE
- executes before PK, FK constrains are checked

AFTER trigger
- executes automatically after the statement that triggered
it completes
- executes after constrains are checked

Answer / jerry joseph

Trigger gets executed when an INSERT UPDATE or DELETE occurs

2 types of triggers are INSTEAD OF triggers and AFTER triggers

Answer / vimal

Trigger is a special type of store procedure.when we are going
to insert,update,delete table automatically trigger is invoked

Answer / subodh devarde

Triggers are special type of stored procedure which execute automatically whenever any changes are occured in table in database after using insert update ,delete command.

Answer / channu mamane

triggers are special type of stored procedure which are
automatically invoked at the time of modifyibg tables

Which are the olap features?

0 Answers  

Can I recover a damaged SQL Server 2008 database with the undamaged .mdb and .ldf files?

3 Answers   Apple,

What is the contrast between sql and pl/sql?

0 Answers  

What are audit control procedures?

0 Answers   Ernst Young, Thomson Reuters,

What are the advantages of the mirroring?

0 Answers  

Observed that some SP’s / Jobs are processing late, how to troubleshoot to improve performance?

1 Answers  

What will you do If the low Performance occurs?

2 Answers  

i want to join two queries....and i want to run them as one after another that is want output of first query then second , then again output of first query then second and so on...

2 Answers  

How do I uninstall sql server 2014?

0 Answers  

Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?

2 Answers  

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

How to connect PK and FK?

2 Answers