jeudi 21 juillet 2016

Update SQL table from Excel without creating a temporary table

I have a table in MS SQL Server 2012 which looks something like what is shown below but with several hundred records id | adminnumber | 1 006 2 012 3 239 4 546 5 123 6 637 I have an excel sheet which contains proposed updates for these several hundred records of the adminnumber field so the sheet contains something like adminnumber original | adminnumber change 006 673 012 134 239 435 546 783 123 347 637 903 Is it possible to write a script to update the adminnumbers from adminnumber original to adminnumber change and is it possible to do so without creating a temporary table?

Aucun commentaire:

Enregistrer un commentaire