DEVFYI - Developer Resource - FYI

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