인생시계의 메모장 인생시계의 메모장

전체 글

• [JAVA] Error: Registry key 'Software\JavaSoft\Java Runtime Environment'\CurrentVersion'

  WEB/JAVA 2020. 12. 18. 14:58

  [JAVA] Error: Registry key 'Software\JavaSoft\Java Runtime Environment'\CurrentVersion' 에러 발생 시 대처 방안 Error: Registry key 'Software\JavaSoft\Java Runtime Environment'\CurrentVersion' has value '1.8', but '1.7' is required. Error: could not find java.dll Error: Could not find Java SE Runtime Environment. 해결방법 윈도우즈 레지스트리 편집기 열기(시작 -> 실행 -> regedit) HKEY_LOCAL_MACHINE\SOFTWARE\JavaSoft\Java Runtime..

  Read More
• [MSSQL] 두 날짜사이에 날짜별 통계 쿼리

  WEB/MSSQL 2020. 12. 18. 14:26

  [MSSQL] 두 날짜사이에 날짜별 통계 쿼리 GROUP BY를 이용하여 날짜별로 합(SUM)한 결과 출력 WITH A AS ( SELECT '20201125' AS STT_DT , '20201225' AS END_DT ), B AS ( SELECT CONVERT(NVARCHAR(8), CONVERT(datetime, (SELECT STT_DT FROM A)), 112) AS [DT] UNION ALL SELECT CONVERT(NVARCHAR(8),DATEADD(D,1,DT),112) AS [DT] FROM B WHERE 1=1 AND dt >= (SELECT STT_DT FROM A) AND dt

  Read More
• [MSSQL] 두 날짜사이에 모든 날짜 출력 쿼리

  WEB/MSSQL 2020. 12. 17. 09:57

  [MSSQL] 두 날짜사이에 모든 날짜 출력 쿼리 WITH A AS ( SELECT '20201125' AS STT_DT , '20201225' AS END_DT ), B AS ( SELECT CONVERT(NVARCHAR(8), CONVERT(datetime, (SELECT STT_DT FROM A)), 112) AS [DT] , DATEPART(DW, CONVERT(datetime, (SELECT STT_DT FROM A))) AS [DATEPART] , DATENAME(DW, CONVERT(datetime, (SELECT STT_DT FROM A))) AS [DATENAME] UNION ALL SELECT CONVERT(NVARCHAR(8),DATEADD(D,1,DT),112) AS [DT] , D..

  Read More
• [FileZilla] 파일질라 새 탭에 연결하기

  WEB/etc 2020. 12. 11. 14:48

  [FileZilla] 파일질라 새 탭에 연결하기 편집 > 설정 > 인터페이스 > 동작 구역에서 '이미 연결된 상태에서 새로 연결을 시작하는 경우(a) : ' 동작 물어보기 또는 새 탭에서 연결하기 선택 후 저장

  Read More
• [MSSQL] RANK를 사용하여 순위 매기기

  WEB/MSSQL 2020. 12. 11. 11:00

  [MSSQL] RANK를 사용하여 순위 매기기 WITH TEMP_TABLE_1 AS ( SELECT '1반' AS [반정보], '일월~' AS [이름], 90 AS [국어], 80 AS [영어], 70 AS [수학] UNION ALL SELECT '1반' AS [반정보], 'Feb!' AS [이름], 70 AS [국어], 60 AS [영어], 100 AS [수학] UNION ALL SELECT '1반' AS [반정보], '3월@' AS [이름], 80 AS [국어], 80 AS [영어], 50 AS [수학] UNION ALL SELECT '1반' AS [반정보], '사월#' AS [이름], 50 AS [국어], 80 AS [영어], 75 AS [수학] UNION ALL SELECT '2반' AS [반정보..

  Read More
• [MSSQL] WHERE절에 LIKE 검색 방법

  WEB/MSSQL 2020. 12. 11. 09:38

  [MSSQL] WHERE절에 LIKE 검색 방법 WITH TEMP_TABLE_1 AS ( SELECT '1반' AS [반정보], '일월~' AS [이름], 90 AS [국어], 80 AS [영어], 70 AS [수학] UNION ALL SELECT '1반' AS [반정보], 'Feb!' AS [이름], 70 AS [국어], 60 AS [영어], 100 AS [수학] UNION ALL SELECT '1반' AS [반정보], '3월@' AS [이름], 80 AS [국어], 80 AS [영어], 50 AS [수학] UNION ALL SELECT '1반' AS [반정보], '사월#' AS [이름], 50 AS [국어], 80 AS [영어], 75 AS [수학] UNION ALL SELECT '2반' AS [반정..

  Read More
• [MSSQL] 테이블 조인하여 UPDATE/DELETE 쿼리

  WEB/MSSQL 2020. 12. 10. 10:00

  [MSSQL] 테이블 조인(JOIN)하여 UPDATE/DELETE 쿼리 UPDATE TABLE_A SET COLUMN_A = TB.COLUMN_B FROM TABLE_A TA INNER JOIN TABLE_B TB ON TA.SEQ= TB.SEQ WHERE .... DELETE FROM TABLE_A FROM TABLE_A INNER JOIN TABLE_B TB ON TA.SEQ = TB.SEQ WHERE TA.COLUMN_A = TB.COLUMN_B

  Read More
• [MSSQL] 컬럼을 로우로 변경하여 출력

  WEB/MSSQL 2020. 12. 9. 09:35

  [MSSQL] 컬럼(COLUMN)을 로우(ROW)로 변경하여 출력 WITH TEMP_TABLE AS ( SELECT '1반' AS '반정보', '일월' AS '이름', 90 AS '국어', 90 AS '영어', 80 AS '수학' UNION ALL SELECT '2반' AS '반정보', '이월' AS '이름', 70 AS '국어', 80 AS '영어', 60 AS '수학' UNION ALL SELECT '3반' AS '반정보', '삼월' AS '이름', 50 AS '국어', 70 AS '영어', 40 AS '수학' ) SELECT * FROM TEMP_TABLE WITH TEMP_TABLE AS ( SELECT '1반' AS '반정보', '일월' AS '이름', 90 AS '국어', 90 AS '영어',..

  Read More