Articles by NGO Quang Minh (Tip/Trick: 1)

Tip/Trick: 1

Articles
Technical Blogs
Tips and Tricks
Reference Articles
Projects

Average article rating:

No articles have been posted.

Average blogs rating:

No blogs have been submitted.

Average tips rating: 4.50

Database Development

SQL Server

Find particular word or text from the entire stored procedure [Tip/Trick]

26 Apr 2011 Updated: 26 Apr 2011 Rating: 4.50/5 Votes: 6 Popularity: 3.50

Licence: CPOL Views: 10,670 Bookmarked: 2 Downloaded: 0

You can create a simple stored procedure like that:DECLARE @StringToSearch varchar(100)SET @StringToSearch = 'GetEmployee'SET @StringToSearch = '%' +@StringToSearch + '%'SELECT Distinct SO.NameFROM sysobjects SO (NOLOCK) INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.ID AND...

Average reference rating:

No reference articles have been posted.

Average project rating:

No projects have been posted.

NGO Quang Minh

United States

This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.