How to a Query to copy data from on table to another table.

Answers were Sorted based on User's Feedback



How to a Query to copy data from on table to another table...

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.

Is This Answer Correct ?    3 Yes 0 No

How to a Query to copy data from on table to another table...

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

Is This Answer Correct ?    1 Yes 1 No

How to a Query to copy data from on table to another table...

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

Is This Answer Correct ?    0 Yes 0 No

How to a Query to copy data from on table to another table...

Answer / gali kondareddy

INSERT INTO TABLE_2 SELECT * FROM TABLE_1


OR


INSERT INTO TABLE_2 SELECT * FROM TABLE_1 WHERE 1=1

Is This Answer Correct ?    0 Yes 0 No

How to a Query to copy data from on table to another table...

Answer / abhik kumar basu

SELICT * INTO A1 FROM A2

Is This Answer Correct ?    0 Yes 0 No

How to a Query to copy data from on table to another table...

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.

Is This Answer Correct ?    1 Yes 5 No

Post New Answer

More SQL Server Interview Questions

List the types of recovery model available in sql server?

0 Answers  


Is trigger fired implicitely?

2 Answers  


What is dbcc updateusage?

0 Answers  


What is stored in the mssqlsystemresource database? : sql server database administration

0 Answers  


What are the fixed server level roles? : sql server security

0 Answers  






What is the difference between local and global temporary tables?

0 Answers  


write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,


What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  


Do you know what are acid properties of transaction?

0 Answers  


What is the difference between function and stored procedure in sql server?

0 Answers  


What command is used to rename the database?

0 Answers  


How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.

1 Answers  


Categories