时间:2021-07-01 10:21:17 帮助过:43人阅读
获取SQLServer数据库中所有的用户存储过程。 无 SELECT SCHEMA_NAME(sp.schema_id) AS [Schema],sp.name AS [Name] FROM sys.all_objects AS spWHERE(sp.type = N'P' OR sp.type = N'RF' OR sp.type=N'PC')and(CAST( case WHEN sp.is_ms_shipped = 1 THEN 1 W
获取SQL Server数据库中所有的用户存储过程。 <无>SELECT SCHEMA_NAME(sp.schema_id) AS [Schema],sp.name AS [Name] FROM sys.all_objects AS sp WHERE (sp.type = N'P' OR sp.type = N'RF' OR sp.type=N'PC')and(CAST( case WHEN sp.is_ms_shipped = 1 THEN 1 WHEN ( SELECT major_id FROM sys.extended_properties WHERE major_id = sp.object_id and minor_id = 0 and class = 1 and name = N'microsoft_database_tools_support') IS NOT NULL THEN 1 ELSE 0 END AS bit)=N'0') ORDER BY [Schema] ASC,[Name] ASC ? ? ?