查询需要的字符串所在的存储过程及函数 无 CREATE PROCEDURE[dbo].[StringSearchInSQLObject] @TextToSearchVARCHAR(2000)ASSELECT DISTINCTOBJECT_NAME(sc.id)AS’OBJECT NAME’,USER_NAME(so.uid)AS’OBJECT OWNER’,CASEWHEN so.xtype=’C’THEN’CHECK constrai
查询需要的字符串所在的存储过程及函数
<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
–>
CREATE PROCEDURE[dbo].[StringSearchInSQLObject] @TextToSearchVARCHAR(2000)ASSELECT DISTINCTOBJECT_NAME(sc.id)AS'OBJECT NAME',USER_NAME(so.uid)AS'OBJECT OWNER',CASEWHEN so.xtype='C'THEN'CHECK constraint'WHEN so.xtype='D'THEN'DEFAULT or DEFAULT constraint'WHEN so.xtype='F'THEN'FOREIGN KEY constraint'WHEN so.xtype='L'THEN'Log'WHEN so.xtype='FN'THEN'Scalar function'WHEN so.xtype='IF'THEN'Inlined table-function'WHEN so.xtype='P'THEN'Stored procedure'WHEN so.xtype='PK'THEN'PRIMARY KEY constraint (type is K)'WHEN so.xtype='RF'THEN'Replicatio<p>本文来源gao!%daima.com搞$代*!码$网9</p>n filter stored procedure'WHEN so.xtype='S'THEN'System table'WHEN so.xtype='TF'THEN'Table function'WHEN so.xtype='TR'THEN'Trigger'WHEN so.xtype='U'THEN'User table'WHEN so.xtype='UQ'THEN'UNIQUE constraint (type is K)'WHEN so.xtype='V'THEN'View'WHEN so.xtype='X'THEN'Extended stored procedure'END AS'OBJECT TYPE',CASEWHEN sc.encrypted=0THEN'Not encrypted'WHEN sc.encrypted=1THEN'Encrypted'END AS'ENCRYPTED',CASEWHEN sc.compressed=0THEN'Not compressed'WHEN sc.compressed=1THEN'Compressed'END AS'COMPRESSED',so.crdate AS'CREATE DATE',sc.id AS'OBJECT ID'FROM syscomments sc INNER JOIN sysobjects soONsc.id=so.idWHERE sc.textLIKE@TextToSearchORDER BY'OBJECT TYPE','OBJECT NAME'
转载请注明原文链接：查询需要的字符串所在的存储过程及函数
