I have an exisiting SQL DB with location information. One field contains a tekst code (non key) for each location. This code is going to change so for the entire table i have to replace these codes with the new ones.
I have a csv with all de id fields an de new codes.
How can i import/replace the codes? I use mssql servermanagerment studio 18
In principle, you can import the csv file into a new table and then write an update query for the location table.
However, without knowing the structure of your table, csv file and what exactly you need to do, I have no other suggestions.