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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-05 : 07:30:15
|
| Pierre writes "Hi.I'm using MS SQL Server2000 SP3 on a WindowsXP Pro. Inside Enterprise Manager, I have table1 inside database1 and table2 inside database2. Both are on the same server. I need to copy table1 to table2. As in syncronizing the two tables. What SQL script is being used using Query Analyzer? Or if you know the syntax in VB script.Thank you very much and more power.Regards,Pierre" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-05 : 07:41:39
|
| [code]INSERT INTO DB2.DBO.TABLE2(COL1, COL2, ...)SELECT COL1, COL2, ...FROM DB1.DBO.TABLE1[/code]Harsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
|
|
|
Copying Data from one Table to another Table