SELECT * FROM sysobjects WHERE id IN (
SELECT id FROM syscomments WHERE text LIKE '%CharterBaseID%'
)
or
SELECT DISTINCT so.name , replace(replace(replace(replace(sc.TEXT,CHAR(9), ''),CHAR(13),''),CHAR(10),''),CHAR(32),'') , so.xtype
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%키워드%'
or
SELECT DISTINCT so.name , replace(replace(replace(replace(sc.TEXT,CHAR(9), ''),CHAR(13),''),CHAR(10),''),CHAR(32),'') , so.xtype
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE sc.TEXT LIKE '%키워드%'
728x90
반응형
'DataBase > SQL Server' 카테고리의 다른 글
| MS SQL 에서 CURSOR 사용하기1 (0) | 2010.09.16 |
|---|---|
| MS SQL 로우를 칼럼으로 (0) | 2010.09.16 |
| Column Comment 달기( fn_listextendedproperty, sp_addextendedproperty ) (0) | 2010.07.26 |
| 로그파일 지우기 (0) | 2009.04.13 |
| [CTE] 계층구조 쿼리 (0) | 2008.08.22 |