Codice: Seleziona tutto
USE nomedb
GO
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%testo da cercare%'
AND ROUTINE_TYPE='PROCEDURE'
Codice: Seleziona tutto
USE nomedb
GO
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%testo da cercare%'
AND ROUTINE_TYPE='PROCEDURE'