|
How databases can be integrated with other new technologies - Stored Procedures
What is Database Administrator, what is this job like?
(Continued from previous question...)
How databases can be integrated with other new technologies - Stored Procedures
Stored Procedures
Stored procedures can be thought of as programs that live in a database. The procedural logic of a stored procedure is maintained, administered, and executed through the database commands. The primary reason for using stored procedures is to move application code from a client workstation to the database server. Stored procedures typically consume less overhead in a client/server environment because one client can invoke a stored procedure that causes multiple SQL statements to be run. The alternative, the client executing multiple SQL statements directly, increases network traffic and can degrade overall application performance.
A stored procedure is a freestanding database object; it is not "physically" associated with any other object in the database. A stored procedure can access and/or modify data in many tables.
(Continued on next question...)
Other Interview Questions
| 