14 September 2012

Stored Procedure that change in last N days in Sql Server

Stored Procedure that change in last N days in Sql Server


SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 7
----Change 7 to any other day value



-

No comments:

Post a Comment

Comments Welcome

Subscribe to: Post Comments (Atom)

Benefits of microservices

Benefits of microservices      1. Development & Team Agility Architecture- and language-neutral: Teams aren't locked into one progr...