获取SQL Server数据库中所有的用户存储过程

获取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数据库中所有的用户存储过程。 <style> .CodeEntity .code_pieces ul.piece_anchor{width:25px;position:absolute;top:25px;left:-30px;z-index:1000;} .CodeEntity .code_pieces ul.piece_anchor li{width:25px;background: #efe;margin-bottom:2px;} .CodeEntity .code_pieces ul.piece_anchor li{border-left:3px #40AA63 solid;border-right:3px #efe solid;} .CodeEntity .code_pieces ul.piece_anchor li:hover{border-right:3px #40AA63 solid;border-left:3px #efe solid;} .CodeEntity .code_pieces ul.piece_anchor li a{color: #333;padding: 3px 10px;} .CodeEntity .code_pieces .jump_to_code{visibility:hidden;position:relative;} .CodeEntity .code_pieces .code_piece:hover .jump_to_code{visibility:visible;} .CodeEntity .code_pieces .code_piece:hover .jump_to_code a{text-decoration:none;} .CodeEntity .code_pieces h2 i{float:right;font-style:normal;font-weight:normal;} .CodeEntity .code_pieces h2 i a{font-size:9pt;background: #FFFFFF;color:#00A;padding: 2px 5px;text-decoration:none;} </style> <!—ecms

–> <!—ecms
• $velocityCount

–> <!—ecms

–>

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      <a style="color:transparent">来@源gao*daima.com搞@代#码网</a>       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???

喜欢 (0)赏

[搞代码]

分享 (0)