廣告：

SELECT COUNT(*) AS 'Number of Stored Procedures'
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE';

SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE';

SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE' order by created

SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE' order by last_altered

二

SELECT
Name,--存儲(chǔ)過程名字
Definition --存儲(chǔ)過程內(nèi)容
,created,last_altered
FROM sys.sql_modules AS m
INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id
WHERE o.[type] = 'P'

SELECT
Name,--存儲(chǔ)過程名字
Definition --存儲(chǔ)過程內(nèi)容
,create_date,modify_date
FROM sys.sql_modules AS m
INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id
WHERE o.[type] = 'P'

SELECT
Name,--存儲(chǔ)過程名字
Definition --存儲(chǔ)過程內(nèi)容
,create_date,modify_date
FROM sys.sql_modules AS m
INNER JOIN sys.all_objects AS o ON m.object_id = o.object_id
WHERE o.[type] = 'P' order by modify_date desc

三
USE [YourDatabaseName];
GO

SELECT COUNT(*) AS NumberOfStoredProcedures
FROM sys.procedures;

SELECT *
FROM sys.procedures;

SELECT *
FROM sys.procedures order by create_date desc;

SELECT *
FROM sys.procedures order by modify_date desc;

廣告：