1 Articles, Search for '2010/09/29'

  1. 2010/09/29 [SQLServer] 특정문자가 포함된 StoredProcedure 찾기
DATABASE/SQLServer2010/09/29 16:52

[SQLServer] 특정문자가 포함된 StoredProcedure 찾기

1. 특정 문자가 포함된 SP 검색

SELECT A.NAME
FROM SYSOBJECTS A, SYSCOMMENTS B
WHERE A.ID = B.ID
   AND B.TEXT LIKE '%' + '김승태' + '%'

2. 특정 이름의 SP 검색

SELECT A.NAME
FROM SYSOBJECTS A, SYSCOMMENTS B
WHERE A.ID = B.ID
   AND A.NAME LIKE '%' + @sp_name + '%'

크리에이티브 커먼즈 라이센스
Creative Commons License
2010/09/29 16:52 2010/09/29 16:52
Posted by 엉
Tags
No Trackback No Comment

Leave your greetings.