//MSSQL Excel 데이터 마이그레이션 본문

프로그래밍/MSSQL - 팁

//MSSQL Excel 데이터 마이그레이션

= "SELECT " & IF(OR( A2 = "GETDATE()",  A2 = "NULL"),  A2, "'" &  A2 & "'") & " AS [" & $A$1  & "], "
            & IF(OR( B2 = "GETDATE()",  B2 = "NULL"),  B2, "'" &  B2 & "'") & " AS [" & $B$1  & "], "
            & IF(OR( C2 = "GETDATE()",  C2 = "NULL"),  C2, "'" &  C2 & "'") & " AS [" & $C$1  & "], "
            & IF(OR( D2 = "GETDATE()",  D2 = "NULL"),  D2, "'" &  D2 & "'") & " AS [" & $D$1  & "], "
            & IF(OR( E2 = "GETDATE()",  E2 = "NULL"),  E2, "'" &  E2 & "'") & " AS [" & $E$1  & "], "
            & IF(OR( F2 = "GETDATE()",  F2 = "NULL"),  F2, "'" &  F2 & "'") & " AS [" & $F$1  & "], "
            & IF(OR( G2 = "GETDATE()",  G2 = "NULL"),  G2, "'" &  G2 & "'") & " AS [" & $G$1  & "], "
            & IF(OR( H2 = "GETDATE()",  H2 = "NULL"),  H2, "'" &  H2 & "'") & " AS [" & $H$1  & "], "
            & IF(OR( I2 = "GETDATE()",  I2 = "NULL"),  I2, "'" &  I2 & "'") & " AS [" & $I$1  & "], "
            & IF(OR( J2 = "GETDATE()",  J2 = "NULL"),  J2, "'" &  J2 & "'") & " AS [" & $J$1  & "], "
            & IF(OR( K2 = "GETDATE()",  K2 = "NULL"),  K2, "'" &  K2 & "'") & " AS [" & $K$1  & "], "
            & IF(OR( L2 = "GETDATE()",  L2 = "NULL"),  L2, "'" &  L2 & "'") & " AS [" & $L$1  & "], "
            & IF(OR( M2 = "GETDATE()",  M2 = "NULL"),  M2, "'" &  M2 & "'") & " AS [" & $M$1  & "], "
            & IF(OR( N2 = "GETDATE()",  N2 = "NULL"),  N2, "'" &  N2 & "'") & " AS [" & $N$1  & "], "
            & IF(OR( O2 = "GETDATE()",  O2 = "NULL"),  O2, "'" &  O2 & "'") & " AS [" & $O$1  & "], "
            & IF(OR( P2 = "GETDATE()",  P2 = "NULL"),  P2, "'" &  P2 & "'") & " AS [" & $P$1  & "], "
            & IF(OR( Q2 = "GETDATE()",  Q2 = "NULL"),  Q2, "'" &  Q2 & "'") & " AS [" & $Q$1  & "], "
            & IF(OR( R2 = "GETDATE()",  R2 = "NULL"),  R2, "'" &  R2 & "'") & " AS [" & $R$1  & "], "
            & IF(OR( S2 = "GETDATE()",  S2 = "NULL"),  S2, "'" &  S2 & "'") & " AS [" & $S$1  & "], "
            & IF(OR( T2 = "GETDATE()",  T2 = "NULL"),  T2, "'" &  T2 & "'") & " AS [" & $T$1  & "], "
            & IF(OR( U2 = "GETDATE()",  U2 = "NULL"),  U2, "'" &  U2 & "'") & " AS [" & $U$1  & "], "
            & IF(OR( V2 = "GETDATE()",  V2 = "NULL"),  V2, "'" &  V2 & "'") & " AS [" & $V$1  & "], "
            & IF(OR( W2 = "GETDATE()",  W2 = "NULL"),  W2, "'" &  W2 & "'") & " AS [" & $W$1  & "], "
            & IF(OR( X2 = "GETDATE()",  X2 = "NULL"),  X2, "'" &  X2 & "'") & " AS [" & $X$1  & "], "
            & IF(OR( Y2 = "GETDATE()",  Y2 = "NULL"),  Y2, "'" &  Y2 & "'") & " AS [" & $Y$1  & "], "
            & IF(OR( Z2 = "GETDATE()",  Z2 = "NULL"),  Z2, "'" &  Z2 & "'") & " AS [" & $Z$1  & "], "
            & IF(OR(AA2 = "GETDATE()", AA2 = "NULL"), AA2, "'" & AA2 & "'") & " AS [" & $AA$1 & "], "
            & IF(OR(AB2 = "GETDATE()", AB2 = "NULL"), AB2, "'" & AB2 & "'") & " AS [" & $AB$1 & "], "
            & IF(OR(AC2 = "GETDATE()", AC2 = "NULL"), AC2, "'" & AC2 & "'") & " AS [" & $AC$1 & "], "
            & IF(OR(AD2 = "GETDATE()", AD2 = "NULL"), AD2, "'" & AD2 & "'") & " AS [" & $AD$1 & "] " & IF(LEN(A3) > 0, " UNION ALL", "") 

'프로그래밍 > MSSQL - 팁' 카테고리의 다른 글

//MSSQL 결과 창 표시(Ctrl + R)  (0) 2017.12.29
//MSSQL 한글로 자동 변환될 때  (0) 2017.05.25

프로그래밍/MSSQL - 팁 Related Articles

MORE