Tuesday, July 22, 2014
Friday, July 18, 2014
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')
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')
Subscribe to:
Posts (Atom)