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

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 ‘%特定字符%’