MS SQL Compiling a Stored Procedure With a Requery

181 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 is the Difference Between VARCHAR and NVARCHAR in SQL Server ...

What is the Maximum Number of Columns a Table in SQL Server ?

Getting Character Count in MS SQL

Benefits of Using Stored Procedures in MS SQL

What is the Filtered Index in SQL Server ?