SQL Server 2008 search
How to search inside a Stored Procedure in SQL Serve开发者_高级运维r 2008?
If you are looking for the searching for specific key in definiton of a stored procedure use INFORMATION_SCHEMA.ROUTINES along with OBJECT_DEFINITION function.
SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE OBJECT_DEFINITION( OBJECT_ID(SPECIFIC_NAME)) LIKE '%<YOUR_KEY>%'
精彩评论