Posts
Sort by recent activity
Search in Stored Procs
Description: Searches the contents of Stored Procs for a given phrase
Shortcut: ssp (Search Stored Procs)
Code:
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHER...
Search DB Schema
Description: Generates sql code to search the schema of a database, useful for big db's where tables have lots of columns, and you can't remember which table it's in
Shortcut: sis (search in schem...