MSSQL에서 특정 문자열이 있는 프로시져 찾기

SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE '%문자열%'
AND OBJECTPROPERTY(id, 'IsProcedure') = 1
AND OBJECT_NAME(id) like '프로시져명%'
GROUP BY OBJECT_NAME(id)
order by OBJECT_NAME(id)

Posted by 태해

2009/11/18 16:57 2009/11/18 16:57
Response
No Trackback , No Comment
RSS :
http://taehae.injece.net/rss/response/141

Trackback URL : http://taehae.injece.net/trackback/141

Leave a comment
« Previous : 1 : 2 : 3 : 4 : 5 : 6 : 7 : 8 : ... 115 : Next »