Obtain all user stored procedures in the SQLServer Database

Obtain all user stored procedures in the SQLServer database. No SELECTSCHEMA_NAME (sp. schema_id) AS [Schema], sp. nameAS [Name] FROMsys. all_objectsASspWHERE (sp. typeNPORsp. typeNRFORsp. typeNPC) and (CAST (caseWHENsp. Reboot)

Obtain all user stored procedures in the SQLServer database. No 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

Obtain all user stored procedures in the SQL Server database. <无>

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    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 0END AS bit)=N'0')ORDER BY [Schema] ASC,[Name] ASC???