Ab Initio Data Warehousing Question:

Download Job Interview Questions and Answers PDF

What is the purpose of having stored procedures in a database?

Ab Initio Interview Question
Ab Initio Interview Question

Answer:

Main Purpose of Stored Procedure for reduse the network trafic and all sql statement executing in cursor so speed too high.

Download Ab Initio Interview Questions And Answers PDF

Previous QuestionNext Question
Why might you create a stored procedure with the with recompile option?What are Cartesian joins?