/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

0 vote388 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote352 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote323 views1 answer
Sql get count without group by
SQL
7 votes323 views3 answers
Select latest entry in sql table
SQL
0 vote319 views1 answer
Mysqldump ignore table
SQL
0 vote313 views1 answer
Which lock mode is not available in sql
SQL
0 vote324 views1 answer
Exectuer myssql .sql
SQL
0 vote336 views1 answer
Sql server user permissions and roles
SQL
0 vote309 views1 answer
Select all tables linked server sql
SQL
2 votes312 views1 answer
Node and mysql like
SQL