SQL
MS SQL and .net Development
Search
Showing posts with label
Word Search
.
Show all posts
Showing posts with label
Word Search
.
Show all posts
Wednesday, November 17, 2010
SQL 2005 - Word Search
Search for a word that a stored procedure might be using. The code bellow shows all the stored procedure that contain the word "DeptID"
SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '% DeptID %'
Older Posts
Home
Subscribe to:
Posts (Atom)