개발자의 사투

DataTable Pivot(DataTable dt, DataColumn pivotColumn, DataColumn pivotValue) { if (dt.isNullOrEmpty() || dt.Rows.Count == 0) return null; // find primary key columns //(i.e. everything but pivot column and pivot value) DataTable temp = dt.Copy(); temp.Columns.Remove(pivotColumn.ColumnName); temp.Columns.Remove(pivotValue.ColumnName); string[] pkColumnNames = temp.Columns.Cast() .Select(c => c.Co..

https://stackoverflow.com/questions/47593142/visual-studio-locked-file Visual Studio locked file I use the latest Visual Studio Community 2017 (15.4). And since i installed Visual Studio (never worked in it before). I have ALWAYS despite version had this issue. After compiling a couple of time... stackoverflow.com //$(TargetPath) == "$(TargetDir)$(TargetFileName)"? 프로젝트 → 속성 → 빌드이벤트 → 빌드 전 이벤트 추..

CONVERT(CHAR(10), DATETIME, 23) 2021-01-02 YYYY-MM-DD CONVERT(CHAR(23), DATETIME, 21) 2021-01-02 13:14:15.678 YYYY-MM-DD HH:MM:SS.MS CONVERT(CHAR(8), DATETIME, 112) 20210102 YYYYMMDD