Re: [Tutor] Bulk update to a SQL Server table

2019-01-07 Thread Alan Gauld via Tutor
On 07/01/2019 02:15, ram wrote: > I load these 7000+ records into a Pandas DataFrame and update a subset of > these records. > > What's the optimal way to update this subset of records to SQL table? First 7000 records is not a lot so performance shouldn't be a big issue even if you do update the

[Tutor] Bulk update to a SQL Server table

2019-01-07 Thread ram
Hi All, I have 7000+ records in a SQL Server table with 3 columns, which uniquely identify each record (I didn't define them as composite primary key). I load these 7000+ records into a Pandas DataFrame and update a subset of these records. What's the optimal way to update this subset of records