Posted By

kencyber on 12/04/09

Tagged

Versions (?)

Last Edited at 12/04/09 01:23pm

Statistics

Viewed 906 times

Favorited by 1 user(s)

Related snippets

Search functions for the occurance of a string

/ Published in: SQL

Searches the code for all functions in the current database and returns results containing the function name, the character index where the first match was found, and a portion of the code where the match occurred.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

DECLARE @term VARCHAR(2000)
SELECT @term = REPLACE('CROSS JOIN', '%', '\%')
 
SELECT ROUTINE_NAME, ROUTINE_TYPE, PATINDEX('%' + @term + '%', ROUTINE_DEFINITION) AS CharacterIndex,
	SUBSTRING(ROUTINE_DEFINITION, PATINDEX('%' + @term + '%', ROUTINE_DEFINITION) - 20, 40 + LEN(@term)) AS MatchingCode
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%' + @term + '%'
	AND ROUTINE_TYPE='FUNCTION'

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.