Ab Initio Data Warehousing Question:

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.


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