develop72 MSSQL 증가되는 넘버 생성 SELECT 'C' + CONVERT(VARCHAR(10), GETDATE(), 112) +REPLICATE('0', 3 - LEN(ISNULL(MAX(CAST(RIGHT(BOARD_NO, 3) AS INT)), 0)+1)) + CAST(ISNULL(MAX(CAST(RIGHT(BOARD_NO, 3) AS INT)), 0)+1 AS VARCHAR) FROM 테이블 WITH (nolock) ; 2021. 8. 5. spring boot + 다중 db + mapper 설정 출처: https://dev-overload.tistory.com/30 [E: overload] 2021. 6. 8. 개발 시 로컬 이미지 보이도록 IIS 이용 https://studyforus.tistory.com/259 2021. 6. 7. 엑셀업로드 https://eugene-kim.tistory.com/46 2021. 5. 25. 날짜 포맷 dateFormat : function(date) { let dt = new Date(date); let yyyy = dt.getFullYear(); let mm = String(dt.getMonth() + 1); let dd = String(dt.getDate()); return String(yyyy) +'-'+ String(mm[1]?mm:'0'+mm[0])+'-'+String(dd[1]?dd:'0'+dd[0]); } 2021. 2. 25. js 테이블 병합 function genRowspan(className){ $("." + className).each(function() { let rows = $("." + className + ":contains('" + $(this).text() + "')"); if (rows.length > 1) { rows.eq(0).attr("rowspan", rows.length); rows.not(":eq(0)").remove(); } }); } 2020. 6. 18. 이전 1 2 3 4 ··· 12 다음