How copy MS SQL table data to another same table in SQL

Question

What is the way to copy MS SQL server table tdata to the same structural table in MS SQL server from C# application

This answer was useful for me. http://stackoverflow.com/questions/4020270/copy-rows-from-one-datatable-to-another-datatable — SergioSalinas, Mar 23 '17 at 06:27
@MantasČekanauskas no its about DataTable, This about MS SQL database table — Gayan Chinthaka Dharmarathna, Mar 23 '17 at 07:33

score -1 · Accepted Answer · answered Mar 23 '17 at 06:27

-1

insert into [TargetTable] from select * from [SourceTable]

answered Mar 23 '17 at 06:27

1 Answers1