Clean Up Stored Procedures Cache with SQL Server

When deploying a stored procedure, cleaning up the database’s cache can help apply changes immediately. Have a look at the following code:

-- Cleans up db's cache
DECLARE @dbID INTEGER
SET @dbID = (SELECT dbid FROM master.dbo.sysdatabases WHERE name = 'DBNameHere')
DBCC FLUSHPROCINDB (@dbID)

The DBCC FLUSHPROCINDB command allows specifying a particular database id, and then clears all the plans from it.