SUJOY SANTRA

Wednesday, 4 December 2013

List of SP or Function containing specific text

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
    FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_DEFINITION LIKE '%searchtext%'
   -- AND ROUTINE_TYPE='PROCEDURE'
Posted by sujoy santra at 11:19 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Comments (Atom)

Search This Blog

Blog Archive

  • ▼  2016 (3)
    • ▼  September (1)
      • Maintaining State of CheckBoxes to checked While ...
    • ►  February (1)
    • ►  January (1)
  • ►  2015 (89)
    • ►  December (3)
    • ►  November (2)
    • ►  October (5)
    • ►  September (8)
    • ►  August (16)
    • ►  July (1)
    • ►  June (18)
    • ►  May (2)
    • ►  March (14)
    • ►  February (11)
    • ►  January (9)
  • ►  2014 (141)
    • ►  December (5)
    • ►  November (13)
    • ►  October (11)
    • ►  September (3)
    • ►  August (16)
    • ►  July (7)
    • ►  June (9)
    • ►  May (32)
    • ►  April (16)
    • ►  March (13)
    • ►  February (13)
    • ►  January (3)
  • ►  2013 (69)
    • ►  December (6)
    • ►  November (2)
    • ►  October (3)
    • ►  September (6)
    • ►  August (43)
    • ►  July (5)
    • ►  June (4)

About Me

My photo
sujoy santra
Bakhrahat, West Bengal, India
View my complete profile

Popular Posts

  • What is difference between RowCreated & RowDataBound events?
     Gridview RowCreated is fired before then RowDataBound Event. If we apply any styles to Gridview Controls we have to choose RowDataBound Ev...

Total Pageviews

Picture Window theme. Powered by Blogger.