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 |
|
gurvanov
Starting Member
5 Posts |
 Posted - 2004-10-06 : 06:49:52
|
| Hi,does anybody know how can I copy a table from one database to another, on the same server. I need to do the same thing that DTS does, but programmatically. In fact I must do it once, the whole table, and after that weekly attach the new data in the second table. There is a column with the import date, so I can filter only the new ones. As there is a way to do it with the DTS , it must be possible to do it with the Transact-SQL, I think.Can someone help me?Thank you!hristo |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-10-06 : 06:55:09
|
| you can:insert into db1..table1select * from db2..table2where filter...--edit: by the way don't double post |
 |
|
|
|
|
|
Copy a table from one database to another