What is a trigger?

Answers were Sorted based on User's Feedback



What is a trigger?..

Answer / guest

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.

Is This Answer Correct ?    7 Yes 0 No

What is a trigger?..

Answer / hari

Trigger is a special kind of storedprocedure automatically
executed when DML Operations done.

Is This Answer Correct ?    7 Yes 0 No

What is a trigger?..

Answer / kumar

In simpler words, triggers act BEHIND-THE-SCENE once they
are created.They are extremely powerful feature of SQL
Server but not exploited fully to the extent they could be..

Is This Answer Correct ?    2 Yes 1 No

What is a trigger?..

Answer / mukesh kumar srivastava

A trigger is a special kind of stored procedure that responds to specific events. There are two kinds of
triggers: Data Definition Language (DDL) Triggers and Data Manipulation Language (DML) Triggers.

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Is the log file is a part of file group?

0 Answers  


Explain error handling in ssis?

0 Answers  


Can you create a logon trigger in sql server 2005 express edition?

0 Answers  


What is self contained sub query?

0 Answers  


Does group by or order by come first?

0 Answers  






can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  


Do you know what are the restrictions that views have to follow?

0 Answers  


What is sql stored procedure?

0 Answers  


Show Practically Sql Server Views are updatable?

0 Answers   QuestPond,


How do I create a stored procedure in sql server?

0 Answers  


How to delete duplicate records from a table?(for suppose in a table we have 1000 Records in that we have 200 duplicate Records , so ,how to findout that duplicate Records , how to delete those Records and arranged into sequence order? one more thing that there is no primary key at all)

5 Answers   Infosys, McAfee,


Is null in sql server?

0 Answers  


Categories