Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
b01
Starting Member
3 Posts |
 Posted - 2004-11-18 : 14:24:40
|
| I want to transfer some data between tables in the the same or different databases. For example, column1 of table1 goes in column3 of table2, etc. I need some help on this, thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-11-18 : 14:27:15
|
| INSERT INTO Table2 (Column3)SELECT Column1FROM Table1Use 3 or 4 part naming convention on your objects if you need to get to other databases.Tara |
 |
|
|
|
|
|
how to transfer data between tables?