0 Replies - 1530 Views - Last Post: 29 July 2008 - 12:49 AM

#1 dineeshd   User is offline

  • member icon

Reputation: 39
  • View blog
  • Posts: 619
  • Joined: 30-June 08

MSSQL Snippet for Keyword Search

Posted 29 July 2008 - 12:49 AM

Description: This snippet will become handy when you want to search for a particular keyword in side your stored procedures and functions.
SELECT ROUTINE_NAME, ROUTINE_DEFINITION, ROUTINE_TYPE 
FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%DATE%' 
ORDER BY ROUTINE_NAME

Is This A Good Question/Topic? 1
  • +

Page 1 of 1