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
- 9009 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
can you implement data mining in SSRS?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is not null constraint?
Do you know the capabilities of cursors?
How is a full-text index updated?
Tell me what is difference between clustered and non clustered index?
When would you use it?
Explain features and concepts of analysis services?
Which joins are sql server default?
What is the simplest way to create a new database in ms sql server?
What is the use of sql profiler in sql server 2012?
Does hive support indexing?
what changed between the previous version of sql server and the current version? : Sql server database administration
How to skip remaining statements in a loop block using continue statements?
Difference between DELETE and TRUNCATE?
