Skip to content

Instantly share code, notes, and snippets.

@calevano

calevano/execute_search_key_list_store_procedure.sql

Created February 21, 2018 00:03
Show Gist options
  • Save calevano/aafe995193946aaa12d264d556b82ee4 to your computer and use it in GitHub Desktop.
Save calevano/aafe995193946aaa12d264d556b82ee4 to your computer and use it in GitHub Desktop.
Download ZIP
Search definition in Store Procedure in sqlServer
Raw
execute_search_key_list_store_procedure.sql
SELECT
ROUTINE_NAME ,ROUTINE_DEFINITION
FROM
INFORMATION_SCHEMA.ROUTINES
WHERE
ROUTINE_DEFINITION LIKE '%Letter%'
AND ROUTINE_TYPE = 'PROCEDURE'
ORDER BY ROUTINE_NAME
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment