select o.name,m.definition from sys.objects o left outer join sys.sql_modules m on o.object_id = m.object_id where m.definition like '%{此处为查找内容}%'