52.6k points Registered user
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.
Exe <SPName> WITH RECOMPILE
Or we can include WITHRECOMPILE in the stored procedure itself.
Get access to your account and question