sql 根据内容查询存储过程

根据提供的引用内容，可以使用以下SQL语句查询存储过程：

SELECT DISTINCT name, text
FROM dbo.syscomments a, dbo.sysobjects b
WHERE a.id = b.id
AND b.xtype = 'p'
AND a.text LIKE '%sys%';

这个查询语句会返回所有存储过程中包含"sys"关键字的名称和内容。\[2\]
#### 引用[.reference_title]
- *1* [用sql语句查询存储过程内容；用SQl 执行存储过程](https://blog.csdn.net/qq_42567524/article/details/118669046)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down1,239^v3^insert_chatgpt"}} ] [.reference_item]
- *2* *3* [sqlserver中根据文本内容查询对应的存储过程](https://blog.csdn.net/weixin_42870215/article/details/130636816)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insert_down1,239^v3^insert_chatgpt"}} ] [.reference_item]
[ .reference_list ]