查询最近修改的存储过程

select name as 存储过程名,create_date as 创建时间,modify_date as 修改时间 from sys.procedures order by modify_date desc