Stored Procedure Question: Download Questions PDF
Explain the benefits of running stored procedure on a database engine?
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.
Download Stored Procedure Interview Questions And Answers PDF
|Explain about the implementation of business logic in Stored procedures?
|Explain about recursive stored procedures?