DEV Community

bikashgosai
bikashgosai

Posted on

1 1

Search Text in stored procedure in SQL Server

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 '%[ABD]%' ESCAPE '\'

===============================================================================
Escape the square brackets:
...
WHERE m.definition Like '%[ABD]%' ESCAPE '\'

Then the square brackets will be treated as a string literals not as wild cards.

Top comments (0)

Image of Docusign

🛠️ Bring your solution into Docusign. Reach over 1.6M customers.

Docusign is now extensible. Overcome challenges with disconnected products and inaccessible data by bringing your solutions into Docusign and publishing to 1.6M customers in the App Center.

Learn more