SQL – Sort Stored Procedures by Last Modified

Posted onAuthorHeelpBook

Sort by Last Modified Stored Procedures MS SQL 2005

-- Last Modified Stored Procedures

SELECT name,create_date,modify_date
FROM sys.procedures
ORDER BY modify_date desc

modify_date is in datetime datatype.

SOURCE

LINK

LANGUAGE
ENGLISH