How To Find Column dependency in SQL Server Store procedure

We can use following queries to find the column dependency in SQL Server Store Procedures i.e.

Example1,

-- THIS QUERY WILL SEARCH IN STORED PROCEDURE ONLY.

SELECT DISTINCT OBJECT_NAME(OBJECT_ID),

            OBJECT_DEFINITION(OBJECT_ID)

            FROM SYS.PROCEDURES

WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%' + 'User_ID' + '%'

GO

Example 2,

-- THIS QUERY WILL SEARCH IN ALL OBJECTS

SELECT OBJECT_NAME(OBJECT_ID),

            DEFINITION

            FROM SYS.SQL_MODULES

WHERE DEFINITION LIKE '%' + 'User_ID' + '%'

            ORDER BY OBJECT_NAME(OBJECT_ID)

GO