Answer / dhiraj kumar

we have to use INSERT INTO method.
with the use of this method we can easily transfer records
from one table to another table but both table should have
similar columns or you need to select same no of columns
and datatype as inserting table

example:table A1 having 2 columns emp_name,emp_address
and A2 having 4 column name,address,city,dept

INSERT INTO A1 select name,address from A2.

Answer / rajdeep gupta

Hi there is a question copy only schema without data from
one table to another

INSERT INTO A1 select name,address from A2 WHERE 1 = 2

Answer / mohamed ibrahim

To Copy the data from one table to another table
for ex . i have the table named as TempMaster that having
the fields ID ,Name .The having the following record
ID Name
1 Raja
2 Mohamed

I want the same record copy to TempMasterArcheived table

to copy this using the following code:
INSERT INTO TempMasterArcheived
EXECUTE
('SELECT * FROM TempMaster ')

ID Name
1 Raja
2 Mohamed

after the output of TempMasterArcheived is as follows

Answer / gali kondareddy

INSERT INTO TABLE_2 SELECT * FROM TABLE_1


OR


INSERT INTO TABLE_2 SELECT * FROM TABLE_1 WHERE 1=1

Answer / abhik kumar basu

SELICT * INTO A1 FROM A2

Answer / rajeshbargode

we have to use INSERT INTO method.
with the use of this method we can easily transfer records
from one table to another table.we can not only use this
method in the same server but can aslo be done across the
server.for exmaple.if we have two table A1 and A2 then the
code is
INSERT INTO A2 select * from A2.

Can sql server 2016 run on windows 7?

0 Answers  

When do you create cluster and noncluster index?

5 Answers   Satyam,

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

Which tcp/ip port does sql server run on? How can it be changed?

0 Answers  

What is transaction server consistency?

0 Answers  

What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  

What is the difference between row_number and dense_rank?

0 Answers  

What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

what is diffrent between store procedure and trigger

2 Answers  

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,