获取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 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???