Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between Triggers and store procedure?
- 2 Answers
- 5451 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 do I know if localdb is running?
Explain the microsoft sql server delete command?
What purpose does the model database server?
What factors you will consider calculating the storage requirement for that view?
What are the tool windows in sql server management studio? : sql server management studio
How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.
What are the disadvantages of merge replication?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What are functions in the sql server?
What will happen if a column containing char type data is changed to the nchar data type?
What is filestream?
What are the differences between DDL, DML and DCL in SQL?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
Who is the owner of a schema in ms sql server?
How we can compare two database data?
