DZone Snippets: stored code http://snippets.dzone.com/posts Thu, 21 Aug 2008 14:21:54 GMT DZone Snippets: stored code Display contents of a Sybase stored procedure http://snippets.dzone.com/posts/show/5895 To print the definition of a stored procedure, execute: <br />------------------------------------------------------- <br /> <br /> <br />sp_helptext <some_stored_procedure> <br /> <br /> Sun, 10 Aug 2008 22:08:50 GMT http://snippets.dzone.com/posts/show/5895 eddiewould (Eddie) Find text in SQL Code http://snippets.dzone.com/posts/show/1176 Simple stored procedure used to find text inside other SQL code - great for dependency checking during development. <br /> <br />Oskar Austegard <br /><a href="http://mo.notono.us">http://mo.notono.us</a> <br /><code> <br />ALTER PROC __FindText <br /> @query varchar(100) <br />AS <br />SELECT DISTINCT name, type <br />FROM sysobjects so INNER JOIN syscomments sc ON so.id = sc.id <br />WHERE text LIKE '%' + @query + '%' <br />ORDER BY name <br /></code> Thu, 19 Jan 2006 02:23:26 GMT http://snippets.dzone.com/posts/show/1176 austegard (Oskar Austegard)