外键约束问题
在跨数据库复制数据的过程中,我要复制到的目标表city上有很多外键约束,系统老是报错:
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_CITY_Market'. The conflict occurred in database 'SPD', table 'Market', column 'MarketID'.
The statement has been terminated.
请问应该如何做才能避免类似的错误,谢谢!