‘,’沙特阿拉伯’,0.1,21.5,50.4666666666667,-1800),( ‘Tenoumer’,” 撒哈拉 </跨度> 沙漠”, ‘毛里塔尼亚’,1.9,22.9166666666667,-10.4083333333333,-19000)(‘流星陨石坑’,‘亚利桑那州’,‘美国’,1.2,35.0333333333333锟“),(‘维尔京群岛’,英国’,‘VG’),(‘维尔京群岛’,美国’,‘VI’),(‘瓦利斯和富图纳’,‘WF’),(‘西 撒哈拉 </跨度> ”, ‘EH’),( ’也门’, ‘YE’),( ‘尚比亚’, ‘ZM’),( ‘津巴布韦’, ‘ZW’)
SELECT * FROM tblCraterSELECT * FROM tblCountry
锟斤拷
因为 tblCrater 接受 NULL 值,您可以保留您的查询并添加此查询。它会改变 tblCrater 的 CountryID 值匹配 tblCountry 同样的价值 CountryName
tblCrater
NULL
CountryID
tblCountry
CountryName
UPDATE tblCrater SET tblCrater.CountryID = tblCrater.CountryID FROM tblCrater INNER JOIN tblCountry ON tblCrater.CountryName = tblCountry.CountryName
编辑:这仅在您只添加一次数据时才有用。如果随着时间的推移将更多数据添加到表中,则触发器可以是替代解决方案
CREATE TRIGGER add_countryid ON tblCrater AFTER INSERT, UPDATE AS BEGIN UPDATE x SET x.CountryID = tblCrater.CountryID FROM tblCrater x INNER JOIN INSERTED i ON i.CraterID = x.CraterID INNER JOIN tblCountry ON x.CountryName = tblCountry.CountryName END GO