CREATE PROCEDURE [dbo].[sp_find_procs_containing]@search VARCHAR(100) = ” AS SET @search = ‘%’ + @search + ‘%’ SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE @search ORDER BY ROUTINE_NAME Tweet
30/08/2007
by Ralph de Ruijter
2 Comments