Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Find text in SQL Code (See related posts)

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
to sql server monotonous stored procedure by austegard on Wed Jan 18 21:23:26 -0500 2006

You need to create an account or log in to post comments to this site.


Click here to browse all 5146 code snippets

Related Posts