SP to search String in TEXT of SPs

Well this is an addendum to my earlier post for searching a specific string in all the Stored Procedures defined in a database and returning the name of the stored procedure in which it is contained. This is optimized based on suggestion of Greg and I thank him for his advise.

4 (1)

2004-04-09

490 reads

Function To Retrieve Last Index

This Function Enables the user to retrieve the Last Index of the character/string in a predetermined string.Eg If you want search for the Last Occurance of 'SQL' in 'SQL SERVER2000 USES ANSI SQL' thenSELECT dbo.LastIndexOf('SQL SERVER2000 USES ANSI SQL','SQL')will return 26.Tested Only in SQL SERVER2000

5 (3)

2004-03-25

2,627 reads

Blogs

Goal Progress for July 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

Data Modeling at your fingertips

By

(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...

How to put a SQL Server Database into Recovery Pending

By

You might be asking why on earth would you want to get a database...

Read the latest Blogs

Forums

buy 100% undetected counterfeit money €$£

By jamesstunt

website...... www.counterfeittrader.com Greetings to everyone . Take the chance now to become rich thereby...

Migrate SQL Sever 2012 Database To Server 2014 and Subsequent Versions

By VSCurtis

Hi Guys, I have an SQL Server 2012 Express database that I would like...

Deploying SQL Server Automatically

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Deploying SQL Server Automatically

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers