How to search/FIND for a text in body of Procedure.

in #sql4 years ago

SELECT name
FROM sys.procedures
WHERE Object_definition(object_id) LIKE '%TextYouWantToSearch%'

select * from sys.syscomments c
inner join sys.objects o on c.id=o.object_id
inner join sys.schemas s on s.schema_id=o.schema_id
where text like '%dim%'

Coin Marketplace

STEEM 0.19
TRX 0.25
JST 0.038
BTC 97262.35
ETH 3392.76
USDT 1.00
SBD 3.02