copy records from one table to another

Question

copy records from one table to another using while loop

Amit Kumar · 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

Gowtham Ramar · Answer

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 BEGIN INSERT INTO [Table2] ([column1],[column2]) select [column1],[column2] from [table1] where primaryId=@Counter SET @Counter = @Counter + 1 CONTINUE ; END

Gowtham Ramar · Answer

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 BEGIN INSERT INTO #sam (vc_emp_id) SELECT vc_emp_id FROM #temp where sno =@Counter set @Counter=@Counter+1 END

Nandha Kumar Nagarajan · Answer

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 BEGIN INSERT INTO sam (vc_emp_id) SELECT vc_emp_id FROM tbl_sam END

Gowtham Ramar · Answer

Send your two table structure i will post query