Skip to main content

Return to Answer

deleted 112 characters in body
Source Link
Martijn Pieters
Martijn Pieters
  • 1.1m
  • 326
  • 4.2k
  • 3.4k

It might help you! click for live demo

SELECT DISTINCT A.NAME AS OBJECT_NAME, A.TYPE_DESC FROM SYS.SQL_MODULES M INNER JOIN SYS.OBJECTS A ON M.OBJECT_ID = A.OBJECT_ID WHERE M.DEFINITION LIKE '%['+@SEARCH_TEXT+']%' ORDER BY TYPE_DESC

It might help you! click for live demo

SELECT DISTINCT A.NAME AS OBJECT_NAME, A.TYPE_DESC FROM SYS.SQL_MODULES M INNER JOIN SYS.OBJECTS A ON M.OBJECT_ID = A.OBJECT_ID WHERE M.DEFINITION LIKE '%['+@SEARCH_TEXT+']%' ORDER BY TYPE_DESC

It might help you!

SELECT DISTINCT A.NAME AS OBJECT_NAME, A.TYPE_DESC FROM SYS.SQL_MODULES M INNER JOIN SYS.OBJECTS A ON M.OBJECT_ID = A.OBJECT_ID WHERE M.DEFINITION LIKE '%['+@SEARCH_TEXT+']%' ORDER BY TYPE_DESC
Source Link
Anil Singh
Anil Singh
  • 4.2k
  • 4
  • 45
  • 49

It might help you! click for live demo

SELECT DISTINCT A.NAME AS OBJECT_NAME, A.TYPE_DESC FROM SYS.SQL_MODULES M INNER JOIN SYS.OBJECTS A ON M.OBJECT_ID = A.OBJECT_ID WHERE M.DEFINITION LIKE '%['+@SEARCH_TEXT+']%' ORDER BY TYPE_DESC