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
Enlist various transaction phases.
Is access a database program?
What database should I learn first?
Explain dml (data manipulation language)?
What are codd rules?
What is normalization? What are different type of normalization?
What's the difference between delete and truncate ?
What is advantages of progress actional?
Is the internet a database?
What is the normal procedure followed by a java client to access the db?
Is it good to store image in database?
What is write ahead logging in DBMS?
How do I delete a database in phpmyadmin?
Define checkpoint.
What are the two main functions of queries in databases?