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 vote334 views1 answer
Mysql update privileges
SQL
3 votes304 views1 answer
How to get list of synonyms in oracle
SQL
3 votes364 views3 answers
Create a view postgres
SQL
5 votes370 views1 answer
Sql add column after another
SQL
2 votes342 views2 answers
Mysql show table column comments sql
SQL
1 vote341 views1 answer
Sql find column name like
SQL
0 vote357 views2 answers
Mysql create table if not exists
SQL
0 vote364 views1 answer
Delete first row in sql
SQL
0 vote395 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
9 votes388 views2 answers
Nosql databases
SQL