-
Functions to find text in column names and in stored procedures and function definitions
Implemented in SQL Server:This function finds a text string in a stored procedure or function definition: CREATE FUNCTION Find_Text_In_SP_or_FN (@StringToSearch varchar(100))RETURNS @fNames TABLE (name sysname)ASBEGIN SET @StringToSearch = ‘%’ + @StringToSearch +’%’ INSERT @fNames SELECT DISTINCT SO.Name FROM sysobjects SO (NOLOCK) INNER JOIN syscomments SC (NOLOCK) on SO.ID = SC.ID AND (SO.Type = ‘P’ OR…
-
Google code search for “I’m an idiot”
My new favorite toy: Google code search Some interesting comments and such left in code: I’m an idiot. Why the hell wtf Some idiot What an idiot Google code search even does regex. How about a string of random ? and !?
-
You can now buy your tank on Amazon.com
"Not recommended for a drunken rampage"