Thursday, July 17, 2014

How to use Bulk insert to insert one column in a mutitple columns table?

One of solutions is:
Create a view from that table with only column you want to update.
The use bulk insert:
bulk insert TableView
from 'July17_2014.csv'
with (fieldterminator = ',', rowterminator = '\n')

No comments:

Post a Comment