MS SQL Compiling a Stored Procedure With a Requery

203 Reads Ms Sql

The following query model is run to recompile the stored procedure in MS SQL with the query.

EXEC sp_recompile '{Our SP Name}'

Here is an example of usage..

EXEC sp_recompile 'SP_UPDATE_CONTACTS'
Ms Sql

You May Interest

What are Sparse Columns in SQL Server ?

What is RAISEERROR in SQL Server ?

Differences Between Stored Procedure and Function in MS SQL

MS SQL Get Current Time GETDATE()

What are Some Advantages of Using CTE in SQL Server ?