Is it possible in SQL Server Management Studio to read a CSV and perform an SQL update per line?
Example
data.csv
"column1","column2,"column3"
"column1","column2,"column3"
"column1","column2,"column3"
"column1","column2,"column3"
"column1","column2,"column3"
I want to run a SQL update based on the data in each line such as
UPDATE [data].[orders] set order_number = $column1, something_else = $column2 where order = $column3
Is this possible to do in SQL Server Management Studio?
Ctrl
+Enter
enters the same value in all cells. – wBob Jul 8 '16 at 8:40