What is a trigger?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How self join is different from outer join?

605


Explain the benefits of user-defined functions?

530


What is the difference between delete and truncate statements?

576


What is difference between view and materialized view?

542


Can you pass expressions to stored procedure parameters?

511






What is user-defined inline table-valued function?

523


What are the rules to use the rowguidcol property to define a globally unique identifier column?

595


What is nolock hint in sql server 2008

639


Explain the microsoft sql server delete command? : SQL Server Architecture

587


Tell me what do you understand by a view? What does the with check option clause for a view do?

647


is it important for a database administrator to understand the operating system and file access? : Sql server administration

590


Can we use where and having clause together?

512


What is an inner join?

530


How to grant a permission in ms sql server using "grant execute" statements?

569


let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

506