Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Triggers and store procedure?
- 2 Answers
- 5667 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
how to use DTS package in 2000,2005,2008 in sql server
what are the critical issues you have resloved in your company
What is a synonym for manipulation?
Do you know sql server 2008 backup compression?
What are transactions and its controls?
can we have a nested transaction? : Sql server database administration
What is the difference between set and select?
Define the one-to-one relationship while designing tables.
what are different types of backups available in sql server? : Sql server database administration
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
How to create a new login name in ms sql server?
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
What are horizontal and vertical scaling?
How do you size a resultset?
Can you roll back the ddl statement in a trigger?
