Ab Initio Data Warehousing Question:
What is the purpose of having stored procedures in a database?
Answer:
Main Purpose of Stored Procedure for reduse the network trafic and all sql statement executing in cursor so speed too high.
Previous Question | Next Question |
Why might you create a stored procedure with the with recompile option? | What are Cartesian joins? |