What are Stored Procedures and When would we Use Them?
- 1 Answers
- 307 Views
- I also Faced
- E-Mail Answers
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 |
What is 'cross join'? Or what is cartesian product?
How data are stored in database?
What are the steps involved in Database Shutdown ?
What is Dedicated server configuration ?
What is the easiest database to learn?
What does partition mean in database?
Explain a database server?
What is the relationship?
What are database modules?
Is facebook a database?
WHEN YOU FIRE A QUERY IT WILL SLOW WHAT WILL U DO.
What is a string in database?
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
