Find all store procedure related to table in SQL Server


Problem: Sometimes, we need to find procedures where a particular table has been used.
Solution: The following query may help you to find all the procedures in which a particular table exists. It may also be used to find text use in procedures.
SELECT DISTINCT a.name,b.text,a.crdate
FROM sys.syscomments b
INNER JOIN sys.sysobjects a ON b.id=a.id
WHERE b.TEXT LIKE '%tblName%
Note: sc.text return all the text of the stored procedure.

PostgreSQL-Query: Sort result set by specific field values using ORDER BY Clause

Problem: Suppose we have a book_inventory table which has some columns such as id, isbn, title, author, publisher, publish_date, etc.. whe...