Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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
Comment

PREVIOUS NEXT
Code Example
Sql :: Provera dupliranih konatakata 
Sql :: database restoring error 
Sql :: query to fetch 50% records from the table. 
Sql :: downgrading sql localdb visual studio 
Sql :: how to set sql_mode for a query in CI model 
Sql :: mysql update all record removing 2 hours from column 
Sql :: postgresql copy backup table 
Sql :: INSERT INTO RAHULDEV 
Sql :: snowflake last query id 
Sql :: oracle generate sequence of numbers 
Sql :: grepper sql workbench download 
Sql :: tsql default value when no value returned by query 
Sql :: select count(*) from table 
Sql :: mysql streaming example 
Sql :: sql find column with trailing space 
Sql :: user multiple mysql server mac 
Sql :: create table as select sql server error 
Sql :: ms sql convert hijri to gregorian 
Sql :: mysql query problems and solutions 
Sql :: mysql convert charset 
Sql :: $nbreLivres= mysqli_num_rows($result); $all = mysqli_fetch_all($result,MYSQLI_ASSOC); mysqli_free_result($result) mysqli_close($conn); 
Sql :: *Action: Options are to resolve the compilation/authorization errors, disable the trigger, or drop the trigger. 
Sql :: sql orcale i forgot what my name & password was 
Sql :: T-SQL MERGE with condition what is not matched? 
Sql :: joins and views sql 
Sql :: oracle calculate statistics on partition 
Sql :: mysql extract number from string 
Sql :: selects all the columns from the sailors table 
Sql :: set default value now() date 
Sql :: SQL Aliases with MAX() and MIN() 
ADD CONTENT
Topic
Content
Source link
Name
9+9 =