Difference between Triggers and Stored Procedure
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 are the core components of SSRS?
Explain what is the difference between a local and a global temporary table?
What is data modeling and Reterminal integrity?
Where can you find the error log information? : sql server database administration
List the data types available in mssql?
How do I port a number to sql server?
Can we use pragma autonomous_transaction in trigger?
What are the 3 types of schema?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
how to trace the traffic hitting a sql server? : Sql server database administration
How do you test your database? : sql server database administration
Explain following error properties?
Explain sql delete command?
Can we write a distributed query and get some data which is located on other server and oracle database?
What is RAID? What are the different types of RAID configurations?