Hello,
Yes you can copy the data of one table to another with the help of the following code given below
select * into NewTable from Oldtable
above new table is the name of a new table which will b automatically created for you and the oldtable is the name of the table from where u wana copy the data
You can also go for bulk copy method but i feel the above method is the simplest.
Do rate my answer once you find it useful
Thanks & Regards
Radix :rose:
Submit an article or tip