Find Text In SQL Code
Join the DZone community and get the full member experience.Join For Free
Simple stored procedure used to find text inside other SQL code - great for dependency checking during development. Oskar Austegard http://mo.notono.us
ALTER PROC __FindText @query varchar(100) AS SELECT DISTINCT name, type FROM sysobjects so INNER JOIN syscomments sc ON so.id = sc.id WHERE text LIKE '%' + @query + '%' ORDER BY name
Opinions expressed by DZone contributors are their own.