Skip to content

Instantly share code, notes, and snippets.

@NKid

NKid/gist:fa9d2c939772a185e785 Secret

Last active September 1, 2020 01:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save NKid/fa9d2c939772a185e785 to your computer and use it in GitHub Desktop.
Save NKid/fa9d2c939772a185e785 to your computer and use it in GitHub Desktop.
Download ZIP
[搜尋預存程序]
Raw
gistfile1.sql
SELECT obj.Name SPName, sc.TEXT SPText
FROM sys.syscomments sc
INNER JOIN sys.objects obj ON sc.Id = obj.OBJECT_ID
WHERE sc.TEXT LIKE '%' + 'Search Keyword' + '%' AND obj.Type='P'
--sys.objects.Type → P = SQL 預存程序
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment