Search results for 'Stored Procedure'

MSSQL SP내의 특정 테이블 이름 , 문자열 검색


테이블 검색
Select object_name(id) From syscomments Where text like '%tournament_ranking%'
Group by object_name(id)
Order by object_name(id)

문자열 검색
select * from sys.all_objects as o  with(nolock)
inner join sys.sql_modules as a with(nolock) on o.object_id = a.object_id
where a.definition like '%ts_keyword%'
order by o.name asc
2010/12/10 19:23 2010/12/10 19:23
Trackback Address:이 글에는 트랙백을 보낼 수 없습니다