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

What is a transact-sql statement?

616


How to select some specific columns from a table in a query in ms sql server?

627


What are cursors stored procedures and triggers?

595


What are sub reports and how to create them?

103


If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

621






Mention what are the core components of ssrs?

233


How to create new databases with "create database" statements?

655


How to download and install the scaled-down database adventureworkslt?

692


What is query optimization process?

603


Explain difference between cross join and full outer join?

654


Where the sql logs gets stored?

624


What is the difference between value type and reference type?

626


How many levels of sp nesting are possible?

642


Do you know the policy based administration feature of sql server 2008?

656


Can sub report data source be different from that of the parent report?

115