Tuesday, March 24, 2015

How To Find Procedure In Create Days & Modify Days

*** CREATE DAYS ***

SELECT name FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 7


*** MODIFY DAYS ***
 
SELECT name FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 7

No comments :

Post a Comment