Anil Singh | Code-sample.com

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 . OBJ...