About Me

My photo
MCTS FOR SQL SERVER 2008 DOT NET PROGRAMMING WEB DESIGNING

Tuesday, 18 October 2011

Search the desired text in Stored Procedures

hello guys............one interesting thing in sql is you can search text you desired which you used in stored peocedures.....



SYNTAX:-


SELECT definition FROM sys.all_sql_modules WHERE definition LIKE '%FINANCIAL%'





No comments:

Post a Comment