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

SQL Server - Interview Questions

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.

More Technologies Interview Questions