Which command do you use to recompile a procedure?

Options
- Alter Procedure
- Modify Procedure
- Update Procedure
- Recompile Procedure


CORRECT ANSWER : Alter Procedure

Discussion Board
Alter Procedure

Alter Procedure is used to recompile a procedure. The ALTER PROCEDURE statement is very similar to the ALTER FUNCTION statement. The ALTER PROCEDURE statement explicitly recompiles a standalone stored procedure. Explicit recompilation eliminates the need for implicit run-time recompilation and prevents associated run-time compilation errors and performance overhead.

Prajakta Pandit 02-23-2017 06:57 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement