sql stored procedure with out parameter code example

Example 1: find column in all stored procedures sql server

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

Example 2: how to search table name in stored procedure in sql server

SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%TableNameOrWhatever%'

Tags:

Sql Example

Related