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

About this user

Oskar Austegard http://mo.notono.us

« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS 

Find text in SQL Code

Simple stored procedure used to find text inside other SQL code - great for dependency checking during development.

Oskar Austegard
http://mo.notono.us
   1  
   2  ALTER PROC __FindText
   3  	@query varchar(100)
   4  AS
   5  SELECT DISTINCT name, type 
   6  FROM sysobjects so INNER JOIN syscomments sc ON so.id = sc.id
   7  WHERE text LIKE '%' + @query + '%'
   8  ORDER BY name
to sql server monotonous stored procedure by austegard on Jan 18, 2006
« Newer Snippets
Older Snippets »
Showing 1-1 of 1 total  RSS