Answers for "search for each word in sql database"

search text in all sql server stored procedure

SELECT OBJECT_NAME(object_id)
    FROM sys.sql_modules
    WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1
    AND definition LIKE '%Foo%'

Posted by: Guest on June-29-2020

sql searching via key word

SELECT id, category, location
FROM table
WHERE
(
    category LIKE '%keyword%'
    OR location LIKE '%keyword%'
)

Posted by: Guest on April-17-2020

Code answers related to "search for each word in sql database"