Difference between Triggers and Stored Procedure
- 23 Answers
- 69380 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / ajay panchal
Triggers are automatically run but stored procedures are not automatically run and they have to be called explicitly by the user.
we can write a stored procedure within a trigger but cannot write a trigger within a stored procedure.
Trigger is attached to table or view and is fired only when an INSERT, UPDATE, and/or DELETE occurs, while a stored procedure executes at any time when it is called.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How is foreign key related to primary key?
Does transparent data encryption provide encryption when transmitting data across the network?
what is the information that can be stored inside a bit column? : Sql server database administration
How do clustered indexes store data?
explain the storage models of olap? : Sql server database administration
How many triggers you can have on a table?
How check triggers in sql server?
What is RAID? What are the different types of RAID configurations?
What is a deadlock and what is a live lock?
How do you create a data source?
How to enable/disable indexes?
What is merge?
Do you know how to store and query spatial data?
explain extended properties
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
