查找包含某些单词的所有存储过程 [英] Find all stored procedures containing some word

问题描述

如何在SQL Server 2012中搜索所有商店程序并查找所有包含搜索词的内容？

解决方案

hi，



查看此查询，



从INFORMATION_SCHEMA.ROUTINES中选择*，其中ROUTINE_NAME喜欢''sp％''

< blockquote>嗨Ronnie，



我希望这会对你有所帮助



http://networking.ringofsaturn.com/SQL/sql-search-stored-procedures.php [ ^ ]



http：// stackoverflow。 com / questions / 5079457 / how-do-i-find-a-stored-procedure-containing-text [ ^ ]

检查以下代码

  SELECT   DISTINCT   OBJECT_NAME （C.ID）
  FROM  syscomments C 
  INNER   JOIN   FROM  sys.procedures P  ON  P.Name = OBJECT_NAME（C.ID）
  WHERE  C. 文本  LIKE  ' ％Search_String ％' 
  AND  P.  type  = '  P' 

问候，

GVPRabu

How to search through all store procedures and find all containing search term in SQL Server 2012 ?

解决方案

hi,

Check this query,

select * from INFORMATION_SCHEMA.ROUTINES where ROUTINE_NAME like ''sp%''

Hi Ronnie,

I hope this would help you

http://networking.ringofsaturn.com/SQL/sql-search-stored-procedures.php[^]

http://stackoverflow.com/questions/5079457/how-do-i-find-a-stored-procedure-containing-text[^]

Hi,

Check the following Code

SELECT DISTINCT OBJECT_NAME(C.ID) 
FROM syscomments C
INNER JOIN FROM sys.procedures P ON P.Name=OBJECT_NAME(C.ID)
WHERE C.Text LIKE '%Search_String%'
AND P.type = 'P'

Regards,
GVPRabu

这篇关于查找包含某些单词的所有存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！