Difference between Triggers and Stored Procedure
- 23 Answers
- 69349 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
Is it possible for a stored procedure to call itself or recursive stored procedure?
What are different types of replication in sql server?
Where is localdb stored?
Do comments need to go in a special place in sql server 2005?
How can I create a new template for import ? : sql server management studio
What is the library index called?
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What command is used to delete a table from the database in the sql server and how?
How to create a view using data from another view?
What is local temp table?
How to check parameter value in stored procedure sql server?
You have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem?
How to change server name in sql server?
How many full-text indexes can a table have?
Explain what is raid and what are different types of raid levels?
