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

483 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,606 reads

Blogs

Weekly reading #26

By

Good morning! It was a tough weekend as we supposed to be in Goteborg...

Delete an Azure DevOps Project

By

Not something you’ll do too often, but you might find yourself doing this if...

Ways to access data in ADLS Gen2

By

With data lakes becoming popular, and Azure Data Lake Store (ADLS) Gen2 being used...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

“Included columns” for non-clustered indexes explained

By Michael Salzmann

Comments posted to this topic are about the item “Included columns” for non-clustered indexes...

Reindexing a database

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Reindexing a database

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers