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
- 8811 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the syntax to execute the sys.dm_db_missing_index_details?
How can sql server instances be hidden? : sql server security
What command is used to create a database in the sql server and how?
Can coalesce return null?
How to convert a numeric expression from one data type to another?
Is it possible to create trigger on views?
What do you understand by mirroring?
which backup strategy you are following at ur company
Why we need sql server?
Explain what is use of dbcc commands?
What is the difference between varchar and nvarchar?
What are the hotfixes and patches in sql server?
Mention the differences between local and global temporary tables.
Do you know hot add cpu in sql server 2008?
When would you use it?
