What are Stored Procedures and When would we Use Them?
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
What is hashing in dbms?
What are the differences between drop, truncate and delete commands?
Explain the difference between physical and logical data independence?
How do you create a report in a database?
How big is google's database?
What are the steps to follow when preparing to create a table?
What is dbms and its functions?
How to retrive a single data from a database
explain the term ‘attribute’?
What is normalization? What are different type of normalization?
What is 'cross join'? Or what is cartesian product?
What is the advantage of database management system?
What is the importance of database in an organization?
What are stand-alone procedures?
Define join types.