How can I find stored procedure by search text in MS-SQL
SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%Search_Text%'
AND ROUTINE_TYPE='PROCEDURE'
order by ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%Search_Text%'
AND ROUTINE_TYPE='PROCEDURE'
order by ROUTINE_NAME
추가: varchar(4000) 보다 큰 sp까지 찾는 방법
SELECT so.name FROM dbo.sysobjects so,dbo.syscomments sc
WHERE so.id=sc.id AND type = 'P'
AND sc.text LIKE '%Search_Text%' ORDER BY so.name
'IT > MS-SQL' 카테고리의 다른 글
| SP 실행 권한 문제 (0) | 2011.03.08 |
|---|---|
| MSSQL 단축키 (0) | 2011.03.02 |
| 내부 프로시저 실행시킬 때 EXECUTE 주의점 (0) | 2011.02.28 |
| MSSQL SELECT절에서 두번째로 높은 값 찾기 (0) | 2011.02.24 |
| MSSQL Cursor in Stored Procedure (0) | 2011.02.22 |
