sql server數據庫查看有多少存儲過程procedures
廣告：
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,--存儲過程名字
Definition --存儲過程內容
,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,--存儲過程名字
Definition --存儲過程內容
,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,--存儲過程名字
Definition --存儲過程內容
,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;
廣告：
