May
Interview questions on stored procedures
- Aarush Shukla
- 05th May, 2021
- 754 Followers
Related Articles
Latest Interview Questions
Pratice HR Questions
About Stored Procedure
The stored procedure is a subroutine of SQL language which can be used and reused for repeated access of elements of data from the database management system. The main uses of stored procedures are data validation, access control mechanisms.Developers use the Stored Procedure to save time, memory and complex processing which needs extensive SQL statements repeatedly. The frequently used SQL statements are accumulated in the Stored Procedure and applications needing them can call the procedures. The most important part of the Stored Procedure is the parameter. Parameters are used to pass values to the procedures for operation. They are mainly of 3 types IN, OUT, INOUT.
Stored procedures Interview questions
Leave A Comment :
Valid name is required.
Valid name is required.
Valid email id is required.
Aarush Shukla
Aarush is a web developer from Surat, Gujarat. He has rich experience in developing web API and dynamic websites and CRM's. He is developing websites and writing technical blogs on programming languages like PHP & RUST. He worked internationally, in-house, and remotely on projects for leading brands, agencies, startups, and charities.