What is difference between Triggers and store procedure?
Answers were Sorted based on User's Feedback
Answer / vidit tyagi
triggers are events which fires automaticaly when any insert
,update or delete command execute
but in case of stored procedure we have to manualy
execute / fire to procedure
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / 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 |
what is a schema in sql server 2005? : Sql server database administration
How do I clean up sql server transaction log?
What do you understand by recursive stored procedure?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
how we use window authentication connection with sql server.?
What Is The Difference Between Primary Key & Super Key
Explain some DBCC commands?
what is normalization? Explain different levels of normalization? : Sql server database administration
What are sql server procedures?
What is the difference between locking and multi-versioning?
How many types of indexes are there in SQL Server?
6 Answers CarrizalSoft Technologies, United Healthcare,
What is a data source file?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)