search text in all sql server stored procedure

SELECT OBJECT_NAME(object_id)
    FROM sys.sql_modules
    WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1
    AND definition LIKE '%Foo%'

View another examples Add Own solution

Log in, to leave a comment

3.75

5

Krish 100200 points

                                    SELECT DISTINCT
       o.name AS Object_Name,
       o.type_desc
  FROM sys.sql_modules m
       INNER JOIN
       sys.objects o
         ON m.object_id = o.object_id
 WHERE m.definition Like '%[ABD]%';

Thank you! 5

3.75 (4 Votes)

0

Are there any code examples left?

Find Add Code snippet

New code examples in category SQL

SQL 2022-03-27 22:45:25 how to get mysql on ubuntu
SQL 2022-03-27 20:00:47 install latest mysql on debian 9
SQL 2022-03-27 19:45:11 sql '=' cannot be applied to date varchar(10) athena
SQL 2022-03-27 19:20:41 sql is not null
SQL 2022-03-27 19:20:39 sql group by error
SQL 2022-03-27 18:35:10 replace null with 0 in sql
SQL 2022-03-27 17:30:32 concat column value of same user in mysql
SQL 2022-03-27 17:05:02 sql developer sql worksheet not showing
SQL 2022-03-27 16:45:07 kill a pid redshift
SQL 2022-03-27 16:00:09 joins in sql server

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

sql server search for specific text in stored procedures how to search for a stored procedure in sql server search stored procedure text how to search stored procedure text in sql server sql server find stored procedure containing text in name sql server find stored procedure containing text sql search string in stored procedures sql search all stored procedures for a string Seach SQL for Text in Stored procedures sql search for stored procedure search string in sql STOREd procedure search text in sp sql server search sql stored procedures for string how to find text in all stored procedures sql server stored proc to search table for string in sql server sql search stored procedure search stored procedure in sql server with text find string in all stored procedures sql server sql server search stored procedures with text search for stored procedure in your database stored procedure as a search stored procedure search search stored procedure for text search stored procedure in SQL search all stored procedures for text search a text in all stored procedures sql server search on stored procedure sql server find a text in stored procedure mssql search stored procedures for text simple search in stored procedure in sql server searching in stored procedure mssql find search text in store procedure how to search sql server stored procedures for a string Search SQL for Text in Stored Procedure search string in all stored procedures in sql server search contents of stored procedures sql server sql server search for stored procedure sql query find text in stored procedure sql query to find text in all stored procedures in all database search text in stored procedures sql server search all procedures for text sql server search text in stored procedure find text in all stored procedures in sql server how to search text in all stored sql server sql server search stored procedures search into stored procedures sql server mssql search all stored procedures for string search a string in stored procedure sql server search text in stored procedure sql server sql server search text of stored procedures sql search for text in code stored procedure search in stored procedure search for each word in sql database search sql stored procedures how to find text in stored procedure sql server best stored procedure for search in sql server find a text in stored procedure sql server search stored procedures by name tsql search stored procedures for text search stored procedure using table sql server find text in procedure find text in stored procedure ms sql find text in stored procedure t sql search text in stored procedure sql search in stored procedure sql server search for a string in all stored procedures of sql server database Search text in stored procedure from different databases in SQL Server search in sql server stored procedure sql server search text in all stored procedures search stored procedures for text how to find a text in stored procedure in sql server sql find text in stored procedure search record sql server using stored procedure search sql server using stored procedure sql search through stored procedures sql server find word in all stored procedures search sql stored procs for word sql server search string stored procedure search for stored procedure in sql server tsql find text in stored procedure how to search specific stored procedure text in sql server sql search through stored procedures for text sql find string in stored procedures sql search by text search text in sp find string in stored procedure sql server search stored procedure in sql server search for text in stored procedure sql server search a word in all stored procedures ssms search in sql value stored rocedure ms sql search string in procedures SQL Select value in all stored procedures search in all sp sql server ms sql sp ssms search on results of query search text in stored procedures code for finding a stored procedure search string in stored procedure find text in stored procedure stored procedure for search functionality in sql server find sql text in stored procedure sql search code search string in all stored procedures sql server search in all stored procedures in sql search in all stored procedures for a string sql server search stored procedures for string current page search item in stored procedure sql server how to get store procedure command text in sql server sql search string in SP sql search sp for text search a text in procedure schema in sql tsql search stored proc for text search for text in sql select specific text in a stored procedure search text inside stored procedures search for any string sql procedure search for any string sql server procedure find text in sql sql server search text in stored procedures how to find specific word in stored procedure through query sql search stored procedures for string find procedure executing text select procedure text to sql server find specific text in all stored procs find a text in stored procedure sql search stored procedures search sql database for string stored procedure for string in all SP SQL sql find a text in stored procedure find text from sp in sql server search value in all stored procedures sql serve search string in procedure sql server search all sql server stored procedures text find sql phrase in stored procedure search in all stored procedures sql stored procedure contained search sql server find text in stored procedure search all procedures for text search sql server for text sql findtext usp find text sql how to find a specific text string in a sql server stored procedure select text from stored procedure sql server search text in all stored procedures sql server sql exec sp find text sql search text in stored procedures sp_textsearch for existing tables in sql sp_textsearch ' in sql search and and store sql search all procs sql sql script to search stored procedures text proc sql server find string in sql server procedure how to check the proc use the string search text in sql find text sql how to query sql for stored proc string look for work stored procedures sql server search content in all stored procedures for a string sql script to find text in sql sql server query text in stored procedure how to search table name start with text in sql sp sql server serach all sps for string Look for a specific word across all stored procedures in a database query sql procedures for string search in sql text how to seach stored procedures in sql server for text search text in all sql server stored procedure search text in all sql server stored procedures sql find string in stored procedure sp search in sql server search sql for text sql query stored procedure text script to search text in stored procedures ms sql find text in all stored procedures search content in store procedure in db SQL search text search through a word in all stored procedure sql search stored procedures for text search sql procedure text Search text in stored procedure in SQL Server sql select all stored procedures for text find text in stored procedure sql server search a text in all stored procedures in sql server find a string in all stored procs search stored proc defenitions sql mssql search text in all sp search tsql procs for phrase search stored procedures

Made with love

Welcome Back!

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Create a Free Account

Sign up to unlock all of IQCode features:

Test your skills and track progress
Engage in comprehensive interactive courses
Commit to daily skill-enhancing challenges
Solve practical, real-world issues
Share your insights and learnings

Create an account

Creating a new code example