关键语句:
update 车辆信息 set 车架号 = (
select 车架号
from sheet1 where CHECKSUM(车牌号码)
in
(select CHECKSUM(车牌号码) from 车辆信息)
),
发动机号 = (
select 发动机号
from sheet1 where CHECKSUM(车牌号码)
in
(select CHECKSUM(车牌号码) from 车辆信息)
),
VIN码 = (
select VIN码
from sheet1 where CHECKSUM(车牌号码)
in
(select CHECKSUM(车牌号码) from 车辆信息)
)
where 车牌号码 = (
select 车牌号码
from sheet1 where CHECKSUM(车牌号码)
in
(select CHECKSUM(车牌号码) from 车辆信息)
)
这是我的语句:
IF NOT EXISTS((
select 车牌号码,车架号,发动机号,VIN码
from sheet1 where CHECKSUM(车牌号码)
in (select CHECKSUM(车牌号码) from 车辆信息)))
BEGIN
insert into 车辆信息(车牌号码,车架号,发动机号,VIN码)
(select 车牌号码,车架号,发动机号,VIN码
from sheet1 where CHECKSUM(车牌号码)
in
(select CHECKSUM(车牌号码) from 车辆信息))
END
ELSE
BEGIN
update 车辆信息 set 车架号 = (
select 车架号
from sheet1 where CHECKSUM(车牌号码)
in
(select CHECKSUM(车牌号码) from 车辆信息)
),
发动机号 = (
select 发动机号
from sheet1 where CHECKSUM(车牌号码)
in
(select CHECKSUM(车牌号码) from 车辆信息)
),
VIN码 = (
select VIN码
from sheet1 where CHECKSUM(车牌号码)
in
(select CHECKSUM(车牌号码) from 车辆信息)
)
where 车牌号码 = (
select 车牌号码
from sheet1 where CHECKSUM(车牌号码)
in
(select CHECKSUM(车牌号码) from 车辆信息)
)
END