Difference between Triggers and Stored Procedure

Answer Posted / pankaj arya

To use stored procedure you have to make a call to that
procedure but Triggers fired automatically when an event is
occurred on the table associated with that Trigger like add,
insert or delete.

Is This Answer Correct ?    108 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you debug a procedure in sql server?

688


how many no of arguments can be passed in procedures and functions

5134


What is the difference between delete and truncate statements?

806


Does any body please help me what question's have asked for SSRS in the interview?

1932


What is exporting utility?

775


How do users use Report Builder with SQL Server data sources?

129


Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

740


How to trouble shoot if unable to connect SQL Server

1729


How ssrs maintain security?

833


How many non clustered indexes there can be on table ?

714


What is the syntax for encrypting a column in SQL Server?

839


What is a trigger and its types?

766


Where the sql logs gets stored?

757


How to select an exiting database using mssql_select_db()?

712


Explain throw statement in sql server 2008?

785