SQL SERVER 查看所有存储过程或视图里包含某个关键字的查询语句

SQL SERVER 查看所有存储过程或视图里包含某个关键字的查询语句

select [name]
      ,[xtype]
from sysobjects o
    ,syscomments s
where o.id = s.id
      and text LIKE '关键字'
order by name asc