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

How to Learn MS SQL Server Version

What are Some Advantages of Using CTE in SQL Server ?

Creating a Stored Procedure in MS SQL

Where are SQL Server Usernames and Passwords Stored in the SQL Se ...

Getting List of System Hard Disks with Free Space in MS SQL Serve ...