Stored Procedure Modified in Last (n) Days

Below is the Query to achieve this:
  1. SELECT * FROM sys.objects  
  2. WHERE TYPE = 'P'  
  3. AND  
  4. DATEDIFF(D, modify_date, GETDATE()) < 5 


 

Ebook Download
View all
Learn
View all