|
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'. See alsofor 'MS SQL - find text or command in a stored procedure' article Slugify 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 stringCopyright 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.
or
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> Do you like it? Rate me on LinkedIn |
© 1996 - 2019 Antonin Foller, Motobit Software | About, Contacts