•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 397,817 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,620 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 2120 | Replies: 1
 |
•
•
Join Date: Apr 2006
Posts: 62
Reputation: 
Rep Power: 3
Solved Threads: 0
Junior Poster in Training
Hi,
i have 2 tables. i have 3 equal colomns in both. I want transfer all data from 1st table to another one. How can i do it?
Thanks
this doesn't work but something like this;
insert into exam (e_score, l_name, s_id)
values (dbo.assignment.e_score, dbo.assignment.l_name, dbo.assignment.s_id)
i have 2 tables. i have 3 equal colomns in both. I want transfer all data from 1st table to another one. How can i do it?
Thanks
this doesn't work but something like this;
insert into exam (e_score, l_name, s_id)
values (dbo.assignment.e_score, dbo.assignment.l_name, dbo.assignment.s_id)
•
•
Join Date: Aug 2005
Posts: 6
Reputation:
Rep Power: 0
Solved Threads: 2
Newbie Poster
Hi,
You can use the below syntax:
The exact sql is as follows:
Eralper
http://www.kodyaz.com
You can use the below syntax:
insert into ... select
The exact sql is as follows:
insert into exam (e_score, l_name, s_id) select e_score, l_name, s_id from assignment
Eralper
http://www.kodyaz.com
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
•
•
•
•
ad advertising ajax architecture asp backup beta business centro crash daniweb database dell developer development doubleclick enterprise google hacker internet linux longhorn mail microsoft mmorpg msdn news novell office open qmail red hat rhel security server smtp software source sql survey suse vista windows windows server
- Reading logs in MS SQL Server 2000 (MS SQL)
- Developing SQL Server 2000 (MS SQL)
- SQL Server 2000 Help (MS SQL)
- SQL SERVER 2000 Login failure in ASP.NET (ASP.NET)
- SQL Server 2000 and VB 6 (Visual Basic 4 / 5 / 6)
- Query conversion from Sybase to MS SQL Server 2000 (MS SQL)
- Ms Sql Server 2000 (MS SQL)
Other Threads in the MS SQL Forum
- Previous Thread: ORDER BY - join column
- Next Thread: need help on replacing a value in a field (MSSQL)
