SQL Excel Concatenate into INSERT Command


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

      ")")
#SQL






你可能感興趣的文章

[27-1] 強制轉型 - 番外篇 ( 運算子預設的規定 ex: ==、+ )

[27-1] 強制轉型 - 番外篇 ( 運算子預設的規定 ex: ==、+ )

資料庫,是『必要』抑或『想要』?

資料庫,是『必要』抑或『想要』?

F2E合作社|安裝與格線|Bootstrap 5網頁框架開發入門

F2E合作社|安裝與格線|Bootstrap 5網頁框架開發入門






留言討論






2
2
2