copy records from one table to another

Nandha Kumar Nagarajan

7y758

copy records from one table to another using while loop

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Kumar7y ago
Accepted answer
Hi,Beast way of data copy from one table to another used below code. 1. Method INSERT INTO newTable SELECT * FROM oldTable 2. You you want to copy some column of a table into another then used below query INSERT INTO newTable (col1, col2, col3) SELECT column1, column2, column3 FROM oldTable
+2
Gowtham Ramar7y ago
try this

create table #tbl_sam -------this is old table------
(vc_emp_id varchar(50)
)

create table #sam -------new table------
(vc_emp_id varchar(50))

INSERT INTO #TBL_SAM VALUES ('101'),('102'),('103'),('104')------
select row_number()over ( order by vc_emp_id) sno ,* into #temp from #TBL_SAM
DECLARE @Counter INT, @TotalCount INT
SET @Counter = 1
SET @TotalCount = (SELECT COUNT(vc_emp_id) FROM #temp)
WHILE (@Counter <=@TotalCount)
BEGIN
INSERT INTO #sam (vc_emp_id) SELECT vc_emp_id FROM #temp where sno =@Counter
set @Counter=@Counter+1
END

0
Nandha Kumar Nagarajan7y ago
these are the tables for samples only

create table tbl_sam -------this is old table------
(vc_emp_id varchar(50)
)

create table sam -------new table------
(vc_emp_id varchar(50))

INSERT INTO TBL_SAM VALUES ('101'),('102'),('103'),('104')------
DECLARE @Counter INT, @TotalCount INT
SET @Counter = 1
SET @TotalCount = (SELECT COUNT(vc_emp_id) FROM tbl_sam)
WHILE (@Counter <=@TotalCount)
BEGIN
INSERT INTO sam (vc_emp_id) SELECT vc_emp_id FROM tbl_sam
END

0
Gowtham Ramar7y ago
Send your two table structure i will post query
0
Gowtham Ramar7y ago
if two table have same structure you can to copy the record

insert into [table2] select * from [table1]

other wise you want row by row insert using while loop try below line
DECLARE @Counter INT, @TotalCount INT
SET @Counter = 1
SET @TotalCount = (SELECT COUNT(*) FROM [Table1])
WHILE (@Counter <=@TotalCount)
BEGIN
INSERT INTO [Table2] ([column1],[column2])
select [column1],[column2] from [table1] where primaryId=@Counter
SET @Counter = @Counter + 1
CONTINUE;
END
+2