从SQLSERVER中快速查询存储过程

 

USE DGCementEMSDB;
GO
SELECT * FROM SYS.all_objects
WHERE ([type] = 'P' OR [type] = 'X' OR [type] = 'PC')
ORDER BY [NAME];
GO

USE DGCementEMSDB;
GO
SELECT * FROM sys.all_objects
WHERE ([type] = 'P' OR [type] = 'X' OR [type] = 'PC')
AND [is_ms_shipped] = 0
ORDER BY [name];
GO