sql merge ?

あれば、UPDATE なければ、Insert ?

---

CREATE TABLE ta

(

 ItemExId integer,

 ItemId  integer,

 AccountExId  integer,

 colorname varchar(10) ,

 EXdate varchar(10) 

)

----------------------------------------------

insert into ta

values 

(1,1,1,'赤',' '),

(2,1,2,' ','2020-01-01'),

(3,2,1,'黄色',' '),

(4,2,1,' ','2020-02-02'),

(5,3,1,'青',' '),

(6,3,2,' ','2020-03-03')

----------------------------------------------

CREATE TABLE tb

(

 ItemExId integer,

 ItemId  integer,

 AccountExId  integer,

 colorname varchar(10) ,

 EXdate varchar(10) 

)

----------------------------------------------

insert into tb

values 

(1,1,1,'赤',' '),

(2,1,2,' ','2020-01-01'),

(3,2,1,'黄色',' '),

(4,2,1,' ','2020-02-02'),

(5,3,1,'青',' '),

(6,3,2,' ','2020-03-03')

----------------------------------------------

ODBC

MSODBCSQL17.DLL

SQLServer2019 CentOS8

Cent OS 8にSQL Server 2019をインストール

https://qiita.com/t_skri/items/54e9a47706ba634a5558

---

sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/8/mssql-server-2019.repo

sudo yum install -y mssql-server


sudo /opt/mssql/bin/mssql-conf setup


systemctl status mssql-server

sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent
sudo firewall-cmd --reload

---

オンプレミスまたはクラウドで SQL Server をお試しください

https://www.microsoft.com/ja-jp/sql-server/sql-server-downloads