Bulk insert in SQL Server database from one table to another -


i have 200k records in 1 table , want insert these records table. read bulk insert query found on msdn website not making sense.

this query

 bulk insert adventureworks2012.sales.salesorderdetail  'f:\orders\lineitem.tbl'     (      fieldterminator =' |',      rowterminator =' |\n'   ); 

what f:\orders\lineitem.tbl , whole not making sense.

i have table 4 columns: id, frm, to1 , country

same in destination table

any easy syntax helpful

i using sql server 2008/12

bulk insert imports external data file. if have data in sql server table, should like:

insert newtable (field1, field2, field3) select field1, field2, field3 oldtable 

do not point bulk insert @ sql server database file. .tbl file referenced in example code text file delimited fields.


Comments

Popular posts from this blog

asp.net mvc - SSO between MVCForum and Umbraco7 -

Python Tkinter keyboard using bind -

ubuntu - Selenium Node Not Connecting to Hub, Not Opening Port -