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

0 vote185 views3 answers
Run sql command line
SQL
0 vote170 views1 answer
Flask sqlalchemy decimal
SQL
0 vote171 views1 answer
Sql column contains special character
SQL
1 vote251 views2 answers
Sql example query
SQL
1 vote190 views5 answers
What is in operator in sql
SQL
5 votes202 views2 answers
Oracle show procedures
SQL
20 votes210 views4 answers
How to find average in sql
SQL
54 votes518 views6 answers
Sql rename column
SQL
15 votes170 views2 answers
Open postgress in terminal mac
SQL
0 vote168 views1 answer
Mysql shell ERROR: Not connected.
SQL