What are Stored Procedures and When would we Use Them?
- 1 Answers
- 318 Views
- I also Faced
- E-Mail Answers
Answer Posted / hr@tgksolutions.com
Precompiled sets of SQL statements that are kept in the database are called stored procedures. They
Encapsulate business logic and intricate SQL queries.
Reduce network traffic (client-server round trips) to boost performance.
By using parameterized queries to limit access to data, you may improve security.
Make sure it is reusable and consistent across many applications.
When carrying out repetitive operations like data validation, business rule enforcement, or batch processing, stored procedures are especially helpful.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why do we need database normalization?
What is a distributed database system?
Have you heard about sixth normal form?
What is a relation schema?
What is sql rdbms?
What are the limitations of database?
What are the components of rdbms?
Explain armstrong rules? How they are complete and/or sound?
What is a database in layman terms?
How do databases help businesses?
What is database host?
What exactly is a database?
Explain the term entity set in dbms?
What information can be stored in a database?
When does checkpoint occur?
