-- MSSQL
모든 Stored Procedure 내의 검색
어린왕자악꿍
2009. 12. 21. 20:27
select distinct syscomments.id as id , sysobjects.name
from syscomments inner join sysobjects on syscomments.id = sysobjects.id
where sysobjects.xtype like 'p' and
(
syscomments.text like '%search_text%'
)
and sysobjects.name like 'UP_%'
from syscomments inner join sysobjects on syscomments.id = sysobjects.id
where sysobjects.xtype like 'p' and
(
syscomments.text like '%search_text%'
)
and sysobjects.name like 'UP_%'