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 vote145 views1 answer
Mysql repair a table
SQL
0 vote149 views1 answer
Psql list view rules
SQL
1 vote142 views1 answer
Hexadec to sql REDSHIFT
SQL
0 vote182 views1 answer
Convert rows into columns in oracle
SQL
2 votes169 views3 answers
Sql server: how to concatenate column data using comma
SQL
0 vote150 views1 answer
Mysql create pool
SQL
2 votes157 views1 answer
SELECT LOCKED FROM public.databasechangeloglock WHERE ID=1
SQL
0 vote153 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
3 votes157 views1 answer
Select table column in sql
SQL
8 votes153 views1 answer
Oracle alter tablespace add datafile autoextend max size
SQL