How to a Query to copy data from on table to another table.
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
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 |
Do you know what is a linked server in sql server?
What stored by the master?
between cast and convert which function would you prefer and why?
What are the different sql server versions?
1.what is the difference between view and cursor? 2.If we do any change in view will it affect the database,similarly when we do changes in cursor will it affect the databse?with certain example?Thanks
Working with TLogs
What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?
11 Answers World Tech, Yardi Software,
Explain what is lock escalation?
What are points to remember while using the fillfactor argument?
According to you what goes into making the best database administrator? : sql server database administration
What is SubQuery in SQL Server 2008
Explain the use of containers in ssis and also their types?