查询关键字在哪个储存过程
总结这个SP，可用于查询需要的字符串所在的存储过程及函数等。
CREATEPROCEDURE[dbo].[StringSearchInSQLObject]@TextToSearchVARCHAR(2000)ASSELECTDISTINCTOBJECT_NAME(sc.id)AS'OBJECT NAME',USER_NAME(so.uid)AS'OBJECT OWNER',CASEWHENso.xtype='C'THEN'CHECK constraint'WHENso.xtype='D'THEN'DEFAULT or DEFAULT constraint'WHENso.xtype='F'THEN'FOREIGN KEY constraint'WHENso.xtype='L'THEN'Log'WHENso.xtype='FN'THEN'Scalar function'WHENso.xtype='IF'THEN'Inlined table-function'WHENso.xtype='P'THEN'Stored procedure'WHENso.xtype='PK'THEN'PRIMARY KEY constraint (type is K)'WHENso.xtype='RF'THEN'Replication filter stored procedure'WHENso.xtype='S'THEN'System table'WHENso.xtype='TF'THEN'Table function'WHENso.xtype='TR'THEN'Trigger'WHENso.xtype='U'THEN'User table'WHENso.xtype='UQ'THEN'UNIQUE constraint (type is K)'WHENso.xtype='V'THEN'View'WHENso.xtype='X'THEN'Extended stored procedure'ENDAS'OBJECT TYPE',CASEWHENsc.encrypted=0THEN'Not encrypted'WHENsc.encrypted=1THEN'Encrypted'ENDAS'ENCRYPTED',CASEWHENsc.compressed=0THEN'Not compressed'WHENsc.compressed=1THEN'Compressed'ENDAS'COMPRESSED',so.crdateAS'CREATE DATE',sc.idAS'OBJECT ID'FROMsyscomments scINNERJOINsysobjects soONsc.id=so.idWHEREsc.textLIKE@TextToSearchORDERBY'OBJECT TYPE','OBJECT NAME'来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/276487/viewspace-659816/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
