34,576
社区成员
发帖
与我相关
我的任务
分享
SELECT TOP 10
name ,
modify_date
FROM sys.all_objects
WHERE type = 'P'
ORDER BY modify_date DESC
SELECT name ,
modify_date
FROM sys.all_objects
WHERE type = 'P'
ORDER BY modify_date DESC
如果是想生成.sql文件的话,可以用bcp结合8、9楼写的代码,把存储过程导出到文件中
SELECT b.name, a.definition
FROM sys.sql_modules a ,
sys.procedures b
WHERE a.object_id = b.object_id
ORDER BY b.modify_date DESC
SELECT TOP 10
*
FROM sys.sql_modules a ,
sys.objects b
WHERE a.object_id = b.object_id
AND b.type = 'P' AND is_ms_shipped =0 --去掉系统的
ORDER BY b.modify_date DESC
SELECT TOP 10
*
FROM sys.sql_modules a ,
sys.objects b
WHERE a.object_id = b.object_id
AND b.type = 'P'
ORDER BY b.modify_date DESC