0 votes
in Technology by (55.6k points)
What is the command used to Recompile the stored procedure at run time?

1 Answer

0 votes
by (55.6k points)

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.

...