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
- 9010 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
Where sql server user names and passwords are stored in sql server? : sql server database administration
List the different normalization forms?
What have included columns when we talk about sql server indexing?
What do you know about system database? : SQL Server Architecture
What is indexing and its types?
Define synonym?
How to call a function from a stored procedure in SQL Server ?
what are the reporting service components in SSRS?
How optimize sql query with multiple joins in sql server?
What is plan freezing?
Explain the usage of floor function in sql server.
How to convert a unicode strings to non-unicode strings?
What keyword you will use to get schema appended to the result set of a ‘for xml’ query?
Difference between connected and disconnected database in .net with sql server?
Comment,Datatypes are unlimited
