Develop Ref/Database Info

[MS-SQL] 특정일로부터 업데이트된 내용 조회

Hugh J 2017. 7. 7. 14:45

SELECT *

FROM sys.sql_modules sm

inner join sys.all_objects ao

on sm.object_id = ao.object_id

WHERE modify_date > '2017-07-01'

order by modify_date desc