What is difference between Triggers and store procedure?
- 2 Answers
- 4450 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
List the types of recovery model available in sql server?
What are “unrepeatable reads”?
What are different types of replication in sql server?
When would you use the stored procedures or functions?
How to replace the Query Result 'Null Value' with a text ?
What is @@rowcount in sql?
What is the use of commit?
What is the difference between an index and a unique index?
Can you explain what is the use of custom fields in report?
How to add a new dsn with the odbc driver for sql server?
What is raiseerror? What is raiseerror?
What does the not null constraint do?
what is a self join? Explain it with an example? : Sql server database administration
How to insert multiple rows with one insert statement in ms sql server?
How to delete an existing row with delete statements in ms sql server?
