Search In the Database using Text

declare @SearchText nvarchar(max)='searchText'
SELECT  o.[name] as object_name
                                                            , sm.[definition]
                                                    FROM sys.sql_modules AS sm
                                                    JOIN sys.objects AS o
                                                        ON sm.object_id = o.object_id
                                                    JOIN sys.schemas AS ss
                                                        ON o.schema_id = ss.schema_id
where sm.[definition] like '%'+@SearchText+'%'

Source: rapidtables.com

Similar codes

21 votes214 views3 answers
Sql server search column name in all tables
SQL
0 vote192 views1 answer
Sql server concat null
SQL
0 vote180 views1 answer
Eliminar ultimo carcacter mysql
SQL
1 vote212 views1 answer
Apex run 404
SQL
20 votes169 views1 answer
Get all table name in sql through php
SQL
1 vote174 views1 answer
Find logged in users mysql
SQL
4 votes186 views1 answer
Mac install mysql
SQL
1 vote183 views1 answer
Tsql find foreign key references
SQL
23 votes189 views3 answers
Sql where contains part of string
SQL
1 vote196 views1 answer
How to convert number to hours and minutes in oracle sql
SQL