Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72715 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 a fill factor?
How do you troubleshoot errors in a SQL Server Agent Job?
What are commit and rollback in sql?
What is parameterized reports in ssrs ?
What is an execution plan? When would you use it?
What happens when converting big values to numeric data types?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is surrogate key? : sql server analysis services, ssas
What is the Difference Between Primary and Foreign Key?
What are the commands used in DCL?
What is ms sql server triggers?
How to create a simple table to test triggers in ms sql server?
What are cursors stored procedures and triggers?
Describe triggers features and limitations?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
