SQL
MS SQL and .net Development
Pages
(Move to ...)
Home
▼
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
‹
›
Home
View web version
No comments:
Post a Comment