SELECT [name] ,
create_date ,
modify_date
FROM sys.all_objects
WHERE type_desc = N‘SQL_STORED_PROCEDURE‘
ORDER BY modify_date DESC
SELECT [name] ,
create_date ,
modify_date
FROM sys.all_objects
WHERE type_desc = N‘SQL_STORED_PROCEDURE‘
ORDER BY modify_date DESC
原文：https://www.cnblogs.com/ssh0715/p/12220996.html