Search Text in Stored Procedure in SQL Server

preview_player
Показать описание
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.
Рекомендации по теме
welcome to shbcf.ru