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 vote160 views1 answer
Mysql error codeigniter
SQL
47 votes197 views6 answers
Add column mysql
SQL
0 vote119 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote133 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
1 vote109 views1 answer
Sql server 2016 reseed identity
SQL
3 votes114 views2 answers
Sql end of month
SQL
2 votes122 views1 answer
Select * from table where name like
SQL
31 votes125 views3 answers
Sql count(*)
SQL
13 votes122 views4 answers
Mysql get last row
SQL
19 votes108 views1 answer
Sqrt(-1)
SQL