Many, many times I need to find some text in one of hundreds stored procedures in Microsoft SQL server. I need to create some procedure for the task
Next t-sql code returns a recordset with list of stored procedures, containing @text.
execute find_text_in_sp 'delete', 'model'List of all stored procedures containing 'delete' command in a 'model' database.
execute find_text_in_sp 'CURSOR'List of all stored procedures containing 'CURSOR'.
for 'MS SQL - find text or command in a stored procedure' articleSlugify for T-SQL/MS SQL - convert string with diacritic to ASCII codeEncode SQL string to ASCII text separated by hyphen (minus), designed for part od URL/URI string
Copyright and use this code
The source code on this page and other samples at https://www.motobit.com/tips/ are a free code, you can use it as you want: copy it, modify it, use it in your products, ...
If you use this code, please:
1. Leave the author note in the source.
2. Link this sample from you page.
<A Href="https://www.motobit.com/tips/detpg_sql-find-text-stored-procedure/" Title="Special stored procedure to find any text inside a source code of all stored procedures in one database/server." >MS SQL - find text or command in a stored procedure</A>
© 1996 - 2014 Antonin Foller, Motobit Software | About, Contacts | (Find us on Google+)