Search text in stored procedure in SQL Server

Try this example to get the list of stored procedure names using the ‘text’ you seek in SQL Server Stored procedures.

It Might Help Your Complex Homework Requires SQL Assignments

 

Example,

SELECT DISTINCT

               SP.NAME,

               SP.TYPE_DESC

FROM SYS.PROCEDURES AS SP

WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%skip%'

                               

/* A different version of the query example, To make the query more appropriate for different coding practices. I hope it will help you */

SELECT DISTINCT

O.NAME AS OBJECT_NAME,

O.TYPE_DESC

FROM SYS.SQL_MODULES AS M

INNER JOIN SYS.OBJECTS AS O

ON M.OBJECT_ID = O.OBJECT_ID

WHERE UPPER(M.DEFINITION) LIKE UPPER('% skip%');