Check out example codes for "find column in all stored procedures sql server". It will help you in understanding the concepts better.

Code Example 1

-- Search column in All Objects
SELECT OBJECT_NAME(OBJECT_ID),
definition
FROM sys.sql_modules
WHERE definition LIKE '%' + 'BusinessEntityID' + '%'
GO

Learn ReactJs, React Native from akashmittal.com