Monday, 3 July 2017

Get storedprocedure name by searchtext

SELECT *
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%SearchText%'

OR

SELECT *
FROM sys.objects
WHERE
type = 'P'
and
OBJECT_DEFINITION(OBJECT_ID) LIKE '%SearchText%'

No comments:

Post a Comment

React Hooks - custom Hook

  v CustomHook Ø React allows us to create our own hook which is known as custom hook. Example – 1 localStorage Demo Step-1 Create ...