DATA/SQLServer
[SQLServer] 특정문자가 포함된 StoredProcedure 찾기
엉
2010. 9. 29. 16:52
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 + '%'
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 + '%'