lunes, 10 de junio de 2013

SQL SERVER - search text in stores procedures

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES 
WHERE ROUTINE_DEFINITION LIKE '%text%' 
AND ROUTINE_TYPE='PROCEDURE'

No hay comentarios:

Publicar un comentario