Copying tables

I am able to query several different msde databases on my network using
Query Analyzer from my pc. Using SQL Query Analyzer from my pc, I need to
copy a table from a database found on my local msde installation to a
database on another pc's msde installation. I was trying to find the SQL
Query syntax on Books Online but I had no luck. Can you help?
Thanks,
Ademar Nunes
Hi,
See BCP OUT and BCP IN in books online.
Thanks
Hari
SQL Server MVP
"Ademar" <Ademar@.noneofyourbusiness.com> wrote in message
news:uo2iGb6uEHA.1260@.TK2MSFTNGP12.phx.gbl...
>I am able to query several different msde databases on my network using
> Query Analyzer from my pc. Using SQL Query Analyzer from my pc, I need
> to
> copy a table from a database found on my local msde installation to a
> database on another pc's msde installation. I was trying to find the SQL
> Query syntax on Books Online but I had no luck. Can you help?
> --
> Thanks,
> Ademar Nunes
>
|||I did, but I was unable to make it work. I tried again, and I'm still
unable. Can you help?
Thanks,
Ademar Nunes
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eFagfq8uEHA.568@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Hi,
> See BCP OUT and BCP IN in books online.
>
> --
> Thanks
> Hari
> SQL Server MVP
>
> "Ademar" <Ademar@.noneofyourbusiness.com> wrote in message
> news:uo2iGb6uEHA.1260@.TK2MSFTNGP12.phx.gbl...
SQL
>
sql

Copying Data

Hi all,
Can i do have two different databases[onse server]. I need to
copy the data from one table to another table[another database].
I dont want to recreate the table, i need to copy only the data how is
it possible?
Thanks in Advance
thomsonINSERT INTO db1.dbo.TableName
SELECT <collist>
FROM db2.dbo.TableName
Roji. P. Thomas
Net Asset Management
https://www.netassetmanagement.com
"thomson" <saintthomson@.yahoo.com> wrote in message
news:1122276930.267683.324740@.g49g2000cwa.googlegroups.com...
> Hi all,
> Can i do have two different databases[onse server]. I need to
> copy the data from one table to another table[another database].
> I dont want to recreate the table, i need to copy only the data how is
> it possible?
> Thanks in Advance
> thomson
>|||hi thomson,
You can select Export Data option from All tasks submenu or write a simple
DTS.
regards,
"thomson" wrote:

> Hi all,
> Can i do have two different databases[onse server]. I need to
> copy the data from one table to another table[another database].
> I dont want to recreate the table, i need to copy only the data how is
> it possible?
> Thanks in Advance
> thomson
>|||All solution are fine , but if u wanna do that
open tbl in one database showing all data
Select all data copy it and paste into the destination table
i hope it will work|||hi saurabh,
That's a good solution without a doubt but that will fail if the table own a
identity field.
Regards,
"Saurabh" wrote:

> All solution are fine , but if u wanna do that
> open tbl in one database showing all data
> Select all data copy it and paste into the destination table
> i hope it will work
>