Ruby on Rails: Change class name into human readable string

thechrisoshow (Chris O'Sullivan) — Wed, 09 Jan 2008 11:04:30 GMT

This turns a class name (like LineItem) into a nice string (like "line item")



 line_item = LineItem.new

 puts line_item.class.name.underscore.humanize.lowcase #spits out "line item"

SQL Server: Search through stored procedures for code

thechrisoshow (Chris O'Sullivan) — Sun, 22 Jul 2007 17:22:15 GMT

This returns the names of stored procedures that contain the text you're looking for.



select so.name as 'storProc'

from sysobjects so

join syscomments sc

on so.id=sc.id

where so.type='P'

and sc.[text] like '%BIT_YOU_WANT_TO_FIND%'

Say for example you're looking for all the stored procedures that mentioned the table 'user_table' - then just use this script and the all the stored procedures that make mention of this will be returned.

DZone Snippets: Thechrisoshow's Code Snippets

Ruby on Rails: Change class name into human readable string

SQL Server: Search through stored procedures for code