To find keywords in SQLServer Functions & stored Procedure

Posted Date: 08 Oct 2009	Resource Type: Code Snippets	Category: SQL
Author: Srikanth Reddy	Member Level: Silver
Rating:	Points: 1

   
      SELECT sys.sysobjects.name, sys.syscomments.text   
      FROM sys.sysobjects INNER JOIN syscomments   
      ON sys.sysobjects.id = sys.syscomments.id   
      WHERE sys.syscomments.text LIKE '%KEYWORD%'   
      AND sys.sysobjects.type = 'P'   
      ORDER BY sys.sysobjects.NAME

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Check Keywords in SQL Server Stored Procs and Functions .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Change Database Name-Sql
	Previous Resource: Go Back to the Parent Report in SSRS
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

More Resources