/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

2 votes288 views1 answer
Codeigniter print last sql query
SQL
0 vote327 views1 answer
Oracle chain step succeeded
SQL
0 vote283 views1 answer
Permission denied postgres \copy csv command line
SQL
10 votes315 views2 answers
Doublon sql
SQL
5 votes293 views4 answers
Change auto increment mysql
SQL
1 vote274 views1 answer
Not exists mysql
SQL
3 votes308 views1 answer
Postgres select max value
SQL
1 vote279 views2 answers
Mysql trim whitespace
SQL
28 votes324 views6 answers
Sql update
SQL
-1 vote285 views1 answer
Ssql to lowercqse
SQL