Difference between Store Procedure and Trigger?

Difference between Store Procedure and Trigger?


Nandita
Views: 1934 | Community Opinion: 3

Tags..  SQL Server  Database  Database Interview

Bookmark this page..



Ask a New Question Go to Home

Community Opinion/Answers
 
Ronita Said..

Triggers are used to initiate a particular activity after fulfilling certain condition.It need to define and can be enable and disable according to need.




prasath Said..

Procedure we need execute manually, trigger fired whn the event is occured(insert ,delete,update,..etc) .
One more thing when we use truncate command the trigger ll not fire,




kishore Said..

triggers are special kind of stored procedures that fires when data modification takes place






Register or Login to Post Your Opinion