Tuesday, September 3, 2013

Search Stored Procedure for Column Name in MS SQL SERVER

SELECT DISTINCT OBJECT_NAME(OBJECT_ID),object_definition(OBJECT_ID)FROM sys.ProceduresWHERE object_definition(OBJECT_ID) LIKE '%' + '{COL_NAME}' +'%'

No comments:

Post a Comment