Filter or Search SQL Stored Procedure using SQL Query

In this post, I will explain how to filter Stored Procedure with containing text in the SQL Server database using SQL Query.  

To filter all stored procedures which contain given text in SQL server we need to write a query using SYS.PROCEDURES table.

DECLARE @Parameter VARCHAR(100)

SET @Parameter = 'employee'

SELECT * FROM SYS.PROCEDURES          

WHERE NAME LIKE '%'+ @PARAMETER +'%'          

ORDER BY MODIFY_DATE DESC