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.