MS SQL tutorial on searching for stored procedure for text
This is a Microsoft SQL tutorial showing how to search stored procedures for text.
Comlimentary video:
SQL schemas: • MS SQL tutorial covering working with mult...
Complimentary SQL:
select ob.name
, ob.type_desc
, mo.definition
from sys.objects ob
inner join sys.sql_modules mo on ob.object_id = mo.object_id
where mo.definition like '%sales%'
and ob.type_desc = 'VIEW'