Find Qery SQL

test from pastebin


--All stored procedure and function

SELECT DISTINCT o.NAME AS Object_Name

,o.type_desc

,left(m.DEFINITION, 500) AS def

FROM sys.sql_modules m

INNER JOIN sys.objects o ON m.object_id = o.object_id

WHERE m.DEFINITION LIKE '%GETDATE%' ESCAPE '\'

--Default value on tables

SELECT table_schema

,table_name

,COLUMN_NAME

,column_default

FROM INFORMATION_SCHEMA.COLUMNS

WHERE column_default LIKE '%GETDATE%' ESCAPE '\'

ORDER BY table_schema

,table_name

--Computed column formula on tables

SELECT a.DEFINITION

,a.NAME

,b.NAME

FROM sys.computed_columns a

INNER JOIN sys.tables b ON a.object_id = b.object_id

WHERE DEFINITION LIKE '%GETDATE%' ESCAPE '\'