MS SQL tutorial on searching for stored procedure for text



MS SQL tutorial on searching for stored procedure for text

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: https://youtu.be/Ql1lmagUpxg

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’