Stored Procedure Interview Question:

Explain the benefits of running stored procedure on a database engine?

Submitted by: Administrator

Stored procedures can run directly run on a data base engine. In industries where automation is the key a stored procedure can run entirely on the data base provided to it and this runs on a specialized data base server. Network communication can be avoided. Also this procedure is useful for execution of complex SQL statements.
Submitted by: Administrator