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 buffer cash and log cache in sql server?
What happens to a trigger with multiple affected rows?
What is report snapshot?
Write a program using SQL queries to find a unique entry in a table.
How to delete duplicate records based on single column from a table?
What are the three different part of rdl file explain them?
What is nonclustered index with included columns ?
How to call stored procedure using http soap?
How we can refresh the view?
What are alternate keys?
Explain about unique identifier data type in sql server?
Explain difference between control flow and data flow?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
List out some of the requirements to set up a sql server failover cluster?
What languages bi uses to achieve the goal?