What is difference between Triggers and store procedure?
- 2 Answers
- 4894 Views
- I also Faced
- E-Mail Answers
Answer Posted / sivasiva
Triggers:
Triggers create event that event pass the value for
insert,update delete automatically updated value for the
table.triggers are event driven sepecified procedure.store
and managed by DBMS.automatically fires the value.
Store procedure:
Fast Accesing.Reduse network traffic.sepatre businees rules
and logic from presentation layer
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Please illustrate physical database architecture? : SQL Server Architecture
How do I shrink an ldf file?
Tell me what is difference between view and materialized view?
What is b tree index?
What is the parse query button used for?
How to retrieve error messages using odbc_errormsg()?
What is 5nf in normalization form?
What should be the fill factor for indexes created on tables? : sql server database administration
What is report snapshot in ssrs?
What is the command dbcc checkdb used for?
Explain the truncate command?
What is the largest component inside a field?
What is function of ROLLUP ?
What do you think of this implementation? Can this be implemented better?
Give main differences between "Truncate" and "Delete".
