/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

10 votes214 views4 answers
Sql server pagination
SQL
0 vote162 views1 answer
Sql find gaps in date ranges
SQL
0 vote141 views1 answer
Mysql multiple count
SQL
0 vote154 views2 answers
Create sequence if not exists postgres
SQL
8 votes162 views3 answers
SQL column name
SQL
0 vote160 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote162 views2 answers
Temp Space
SQL
2 votes148 views1 answer
Install sqlite npm
SQL
0 vote148 views3 answers
Postgres trim string
SQL
1 vote162 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL