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 |
|
ronji
Starting Member
8 Posts |
 Posted - 2004-08-16 : 20:35:41
|
| Hi there,I have a linked the table in SQL. Could you please give me an example of the code I would use in Query analyser to copy the data between db'sTHe linked DB is called products_ncawebstore and the table is productsthe destination DB is ncawebstore and the table is products.regards RonThis linked table was originally exported from the SQL DB, data was added keeping the same structure and now I would like to load it back over the DBKind regards Ron |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-16 : 20:46:35
|
| INSERT INTO ncawebstore.dbo.products (ColumnList...)SELECT ColumnList...FROM LinkedServerName.products_ncawebstore.dbo.productsI would run the SELECT before actually doing the INSERT just in case it is wrong.Tara |
 |
|
|
|
|
|
moving data from a linked DB