SQL Excel Concatenate into INSERT Command


=CONCATENATE("    ('",A2,"', '",B2,"', '",C2,"', '",D2,"', '",E2,"',", 
      "'" ,F2, "',",
      "'" ,G2, "',",
      "'" ,H2, "',",
      "'" ,I2, "',",
      "'" ,J2, "',",
      "'" ,K2, "',",
      "'" ,L2, "',",
      "'" ,M2, "',",
      "'" ,N2, "',",
      "'" ,O2, "',",
      "'" ,P2, "',",
      "'" ,Q2, "',",
      "'" ,R2, "',",
      "'" ,S2, "'",

      ")")
#SQL






你可能感興趣的文章

Leetcode 刷題 pattern - Next Greater Element

Leetcode 刷題 pattern - Next Greater Element

[ 筆記 ] 產品需求文件(參考資料) & Final Project 構思紀錄

[ 筆記 ] 產品需求文件(參考資料) & Final Project 構思紀錄

[FE201] webpack 讓你把各種資源包在一起(基本介紹篇)

[FE201] webpack 讓你把各種資源包在一起(基本介紹篇)






留言討論