查找含有特定字符的存储过程

select p.name, m.definition
from sys.procedures p inner join sys.sql_modules m
on p.object_id = m.object_id
where m.definition like '%150%'

感谢怡红公子