Search Text in Stored Procedure in SQL Server

Опубликовано: 22 Апрель 2025
на канале: parvesh

136

SQL QUERY:

SELECT DISTINCT O.NAME AS OBJECT_NAME, O.TYPE_DESC
FROM SYS.SQL_MODULES M INNER JOIN SYS.OBJECTS O
ON M.OBJECT_ID = O.OBJECT_ID
WHERE M.DEFINITION LIKE '%TEXT%'

------------------------------------------------------------------------------------------------------------

Search a text from all my database stored procedures or any database objects.