Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Triggers and store procedure?
- 2 Answers
- 5666 Views
- I also Faced
- E-Mail Answers
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 |
How you trouble shoot when any job fails
Tell me what is fill factor?
Can you tell me about the concept of ER diagrams?
Mention the differences between substr and charindex in sql server.
Tell me what is the difference between locking and multi-versioning?
What is ms sql server triggers?
Disadvantages of the indexes?
What is normalization of database?
How can we improve performance by using SQL Server profiler?
What are null values in ms sql server?
What are the differences between lost updates and uncommitted dependencies?
What is difference between Triggers and store procedure?
-
Oracle (3253) - 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)
