Stored Procedure Question:

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

Stored Procedure Interview Question
Stored Procedure Interview Question

Answer:

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.


Previous QuestionNext Question
Explain about the implementation of business logic in Stored procedures?Explain about recursive stored procedures?