목록DB (158)

develog

[Oracle] insert all

INSERT ALL INTO AATEST (SEQ, TITLE) VALUES (1, '11') INTO AATEST (SEQ, TITLE) VALUES (2, '22') INTO AATEST (SEQ, TITLE) VALUES (3, '33') SELECT 1 FROM DUAL ;
DB/Oracle 2017. 4. 13. 17:10
[MSSQL] insert all

INSERT INTO TB_LIST (COL1, COL2) VALUES ('VAL11', 'VAL12'), ('VAL21', 'VAL22') ;
DB/MSSQL 2017. 4. 13. 17:07
[MSSQL] 주석 등록, 삭제, 조회

http://dbexpert.tistory.com/1
DB/MSSQL 2017. 4. 12. 17:29
[MSSQL] 결과창 그리드

SSMS (Sql Server Management Studio)결과창 포멧 변경Ctrl + D : 그리드Ctrl + T : 텍스트Ctrl + Shift + F : 파일
DB/MSSQL 2017. 4. 12. 15:41
[MSSQL] DATETIME, VARCHAR 변환

▶ VARCHAR > DATETIMESELECT CONVERT(DATETIME, '20170407'); ▶ DATETIME > VARCHAR-- 112 => YYYYMMDD SELECT CONVERT(VARCHAR, CONVERT(DATETIME, '2017-04-07'), 112); ▶ DATETIME 날짜 기간 검색 -- 20120823 일자 검색 SELECT * FROM MY_TABLE WHERE 1=1 AND REG_DT >= CONVERT(DATETIME, '20120823') AND REG_DT < CONVERT(DATETIME, '20120823') + 1 ;
DB/MSSQL 2017. 4. 7. 13:49
[Oracle] total_sec 을 hh:mm:ss 로 변환

SELECT TO_CHAR(TRUNC(:TOTAL_SEC/3600),'FM9900') || ':' || TO_CHAR(TRUNC(MOD(:TOTAL_SEC,3600)/60),'FM00') || ':' || TO_CHAR(MOD(:TOTAL_SEC,60),'FM00') FROM DUAL 입력 :TOTAL_SEC => 3600 결과 01:00:00
DB/Oracle 2017. 4. 4. 11:59
Prev 1 2 3 4 5 6 7 ··· 27 Next