728x90
SELECT o.name, m.definition
FROM sys.sql_modules m JOIN sys.objects o ON m.object_id = o.object_id AND o.type='P'
728x90
'DB' 카테고리의 다른 글
| (MSSQL) 암시적 트랜잭션(Implicit Transaction) (0) | 2017.04.13 |
|---|---|
| (MSSQL) CURSOR(커서) (0) | 2017.04.13 |
| (MSSQL) SET STATISTICS TIME ON (처리시간 나타내기) (0) | 2017.04.13 |
| (MSSQL) 커서(CURSOR) - STATIC,DYNAMIC,KEYSET (0) | 2017.04.13 |
| (MSSQL) 커서(CURSOR) - FORWARD_ONLY,SCROLL (0) | 2017.04.13 |
