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
What is a transact-sql statement?
How to select some specific columns from a table in a query in ms sql server?
What are cursors stored procedures and triggers?
What are sub reports and how to create them?
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?
Mention what are the core components of ssrs?
How to create new databases with "create database" statements?
How to download and install the scaled-down database adventureworkslt?
What is query optimization process?
Explain difference between cross join and full outer join?
Where the sql logs gets stored?
What is the difference between value type and reference type?
How many levels of sp nesting are possible?
Do you know the policy based administration feature of sql server 2008?
Can sub report data source be different from that of the parent report?