Thursday, June 2, 2011

How to search any specific string in a procedure, stored procedure and many other information.

If you need to find how many DB objects a person created and what is the created and modified date.

Please use the following sql statement for this:

SELECT *
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%search_string%'
AND ROUTINE_TYPE = 'PROCEDURE'

No comments:

Split the String values with a special character in MS Flow to convert this into Array

 Many times we have a requirement to prepare the Mailing address for some of the documents, suppose there are Address Line1, Address Line2, ...