/SQL/Search In the Data using ObjectName

Search In the Data using ObjectName

declare @ObjectName nvarchar(max)='objectName'
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 o.name=@ObjectName

Source: rapidtables.com

Similar codes

1 vote194 views1 answer
Sql group by sum with condition
SQL
10 votes180 views3 answers
Sql check double value
SQL
5 votes184 views2 answers
Sql constraint check value in list
SQL
0 vote185 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL
7 votes196 views3 answers
Postgresql dump and restore db
SQL
4 votes173 views2 answers
DB::transaction
SQL
2 votes173 views1 answer
Mysql how to store lat,lng
SQL
0 vote173 views1 answer
SQL Query Orderby Two or More Columns and by number of characters
SQL
0 vote182 views1 answer
Mysql identified by syntax error
SQL
0 vote187 views4 answers
How to get max salary in each department in sql
SQL