What are Stored procedures?
Networking Interview Questions and Answers
(Continued from previous question...)
52. What are Stored procedures?
A stored procedure ia s named collection of SQL statements and procedural logic that is compiled, verified and stored in a server database. It is typically treated like any other database object. Stored procedures accept input parameters so that a single procedure can be used over the network by multiple clients using different input data. A single remote message triggers the execution of a collection of stored SQL statements. The results is a reduction of network traffic and better performance.
(Continued on next question...)
Other Interview Questions