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
Post a Comment