YouareplanningtoimportcustomerdatafromtheCustomertableandtheCountrytableinyourSQLServer2000databaseintoaSQLServer2005database.Youwanttoensurethatduringtheimportprocess,eachvalueintheCountryCodecolumnoftheCustomertablehasacorrespondingrecordintheCountryCodecolumnintheCountrytableoftheSQLServer2005database.Youdefineaforeignkeybetweenthesetwotables.Thus,referentialintegritywillguaranteethattheimportroutinefailsifthereareanyrecordswhereaCountryCodevaluedoesnotexistintheCountrytablebutdoesexistintheCustomertable.YouneedtoensurethattheimportprocessdoesnotfailifrecordsareencounteredthatdonotexistintheCountrytable.
Whatshouldyoudo?()