Skip to content

Instantly share code, notes, and snippets.

@phpleo

phpleo/buscar_comentarios.sql

Created July 21, 2011 14:43
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save phpleo/1097332 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save phpleo/1097332 to your computer and use it in GitHub Desktop.
Download ZIP
TSQL Stored Proceures
Raw
buscar_comentarios.sql
SELECT 'sp_helptext ' + name
FROM sysobjects o
INNER JOIN syscomments c ON (o.id = c.id)
WHERE
TEXT LIKE '%reemplazar_el_nombre%'
Raw
buscar_en_contenido.sql
-- http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.html
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%foobar%'
AND ROUTINE_TYPE='PROCEDURE'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment