Monday, September 23, 2013

How to find sp modified in last N dates

-- updated in last 6 days
SELECT name
FROM sys.objects
WHERE type = 'I'
AND DATEDIFF(D,modify_date, GETDATE()) < 7


-- created in last 6 days
SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,create_date, GETDATE()) < 7

No comments:

Post a Comment