SELECT so.name AS SPName,
so.crdate AS CreateDate
FROM sysobjects so
WHERE so.type ='P'
AND so.name LIKE '%'
ORDER BY so.name
SP 검색 하다가.....
'Dev & Mng' 카테고리의 다른 글
| Get Quarter in MS-SQL Server (0) | 2008/02/12 |
|---|---|
| Database procedure list in MS-SQL Server (0) | 2008/02/12 |
| Java with UTF-8 (0) | 2008/02/12 |
| Windows Update Downloader (0) | 2008/02/06 |
