Interested to Buy Any Domain ? << Click Here >> for more details...
How to a Query to copy data from on table to another table.
- 6 Answers
- 8810 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
How to check if a table is being used in sql server?
What are the database objects? : SQL Server Architecture
what is the main function of a query parameter?
What do you think of this implementation? Can this be implemented better?
what is bit datatype? : Sql server database administration
Determine how to use the inserted and deleted pseudo tables?
What is transact-sql language?
What is SQL Server?
How many types of subqueries are there in sql server?
Write a SQL query in order to merge two different columns into single column?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What are group functions in query statements in ms sql server?
What are the restrictions while creating batches in sql server?
What is row-level compre?
