What are the places where temporary stored procedures can be used?

920    Asked by KeithSutherland in SQL Server , Asked on Jan 25, 2020
Answered by Keith Sutherland

Below are few benefits for temporary stored procedures:

Used in case if user don't have access to create a procedure , then also user can create the temporary procedure

It help in doing the error handling in case if user want to write 10 statements and execute, use can create a temporary sp and do proper error handling/ transactions and can be executed with transactions

These are used in SSIS packages where you have to work with transactions and do not have access to create a new permanent procedure but can create a temporary procedure and execute

Temporary procedure can be created and tested before the deployment / altering the existing procedure and check/ match the output from the required output

In case of any task if you have any reusable script required for a short term can be made as the procedure can be used as required.



Your Answer

Interviews

Parent Categories