'SQL SERVER' 카테고리의 다른 글
| index에 포함된 include column 조회하기 (0) | 2019.05.23 |
|---|---|
| Extended Event Data Query로 Select (0) | 2019.02.19 |
| SQL SERVER Wait type 조사 (0) | 2018.10.27 |
| DAC 연결방법 (0) | 2018.10.27 |
| 패스워드까지 그대로 로그인(계정) 옮기는법 (0) | 2018.10.27 |
2018. 10. 27. 22:47
SQL SERVER
select distinct
ObjectType = o .type_desc
, ObjectName = o .name
, CodeSequence = c_display. colid
, Code = c_display .[text]
from sys.objects o
inner join sys.syscomments c_search
on c_search .id = o .[object_id]
inner join sys.syscomments c_display
on c_display .id = o .[object_id]
where o.type_desc not in ( 'INTERNAL_TABLE','SERVICE_QUEUE' ,'SYSTEM_TABLE')
and c_search.[text] like '%temp%'
order by 1, 2 , 3