Searching stored procedure list with query statement

This code snippet will return list of stored procedure in your database with your keyword(exists in stored procedure) in stored procedure query.

 

This will display name of stored procedure as well as code in stored procedure