Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Triggers and store procedure?
- 2 Answers
- 5556 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
What are the advantages of paper records?
How to populate a table in sql server?
Can we delete data from a view?
How to create function with parameter in sql server?
What is use of attribute hierarchy ordered ? : sql server analysis services, ssas
What is sql injection and why is it a problem? : sql server security
Difference between group by clause and having clause in SQL?
If no size is defined while creating the database, what size will the database have?
Explain transaction server isolation?
What is delete query?
What are logical database components? : SQL Server Architecture
what are acid properties? : Sql server database administration
What is trigger in salesforce?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
List down some advantages of sql stored procedure?
