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

9 votes189 views4 answers
How to remove duplicate in sql
SQL
1 vote206 views1 answer
Sql week commencing date
SQL
0 vote218 views1 answer
Oracle list subpartitions
SQL
0 vote214 views1 answer
Disable database droping sql
SQL
0 vote194 views1 answer
How to search query in python3 sqlite3
SQL
0 vote207 views4 answers
Change schema in sql server
SQL
1 vote320 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
10 votes215 views1 answer
Oracle dependencies table
SQL
0 vote210 views1 answer
Power bi dax add related shows column but not working
SQL
7 votes200 views1 answer
Safe update mysql
SQL