Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between Triggers and Stored Procedure
- 23 Answers
- 72613 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
How to backup encryption key ?
What is subquery explain with example?
What authentication modes does sql server support?
What is serializable?
What the class forname () does?
What is the server name in sql server?
Do you know sql server 2008 backup compression?
How to create an index on a view?
What is the use of =,==,=== operators?
When should you use an instead of trigger?
Can you please explain the difference between function and stored procedure?
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is collation sensitivity? Explain different types.
What is the maximum length of an alert name?
How can we rewrite sub-queries into simple select statements or with joins?
