SQL
MS SQL and .net Development
Search
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 %'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment