0
What is the command used to Recompile the stored procedure at run time?

Open 1 Answers 51 Views Technology
What is the command used to Recompile the stored procedure at run time?

1 Answer

0

What is the command used to Recompile the stored procedure at run time?

Stored Procedure can be executed with the help of keyword called RECOMPILE.

Example

Exe <SPName>  WITH RECOMPILE

Or we can include WITHRECOMPILE in the stored procedure itself.

by (52.6k points)
...