Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Triggers and store procedure?
- 2 Answers
- 5525 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
between cast and convert which function would you prefer and why?
Explain about sql server login?
What are synonyms?
How to create new tables with "create table" statements in ms sql server?
What is dimension table? : sql server analysis services, ssas
How to get the query of a table in sql server?
what are different types of backups available in sql server? : Sql server database administration
Define clusters?
What are statistics?
How to create a new schema in a database?
Mention the different authentication modes in sql server.
How do indexes help, types?
What is difference between stored procedure and user defined function?
What is a data source file?
Is candidate a key?
