Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 74286 Views
- Claimat, HCL, Protech, Silgate, I also Faced
- E-Mail Answers
Answer Posted / amar goala
The main differnce is that S.P. is explicitly calling for
execute else Onece a Trigger is created Its fired
automatically when any event
occurred like update,insert,delete on table in run time.
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is difference between stored procedure and user defined function?
What does it mean to invest in the index?
Tell me what do you understand by a view? What does the with check option clause for a view do?
what information is maintained within the msdb database? : Sql server administration
How to convert a table data in XML format in sql server?
What are differences in between sql server 2012 and sql server 2016?
Define constraints and give an example of their use?
what are defaults? : Sql server database administration
Explain different types of collation sensitivity?
Can two tables have the same primary key?
What do you understand by the analysis services in sql server?
How will you go about resolving deadlocks?
How to delete database objects with "drop" statements in ms sql server?
Explain different backup plans?
How can change procedure in sql server?
