|
| |
|
|
fmcampos
Posts: 29
Joined: 3/6/2002
From:
Status: offline
 |
Updating Database - 3/24/2002 11:31:42
Hi,
I wonder if someone knows a practical way of updating a tables contents with the contents from another table.
Let's say I have table Customers in a database and the same table Customers in a backup database. What I want to do is to copy the entire table contents in Customer and just overwrite everything on the backup table..
|
|
|
|
jeffmetcalf
Posts: 186
Joined: 3/16/2002
From:
Status: offline
|
RE: Updating Database - 3/24/2002 16:12:48
SQL or Access?
the manner is still the same, just easier in access because you can use the query grid. Open a new query, add the table you want to get the data FROM, click Query, Append Query, select the table to add the data to, and map the fields.
With SQL server it's
insert into tbl_customers2 (Lastname,firstname...etc) from
(select lastname,firstname..etc from tbl_customer1)
the important thing to remember is the column numbers. They will insert firstcol from tbl2 from firstcol tbl2...secondcol tbl1 from secondcol tbl2..how you list them in the statement...not by what you name them.
Edited by - jeffmetcalf on 03/24/2002 16:13:27
| |
|
|
|
jeffmetcalf
Posts: 186
Joined: 3/16/2002
From:
Status: offline
|
RE: Updating Database - 3/24/2002 19:55:42
Well...through ASP it's beyond me, hoss. I'm still a babe in woods here. I know you can connect a web to more than one db. And your query string would have to be 'fully qualified'
ie
select into db2.tblcustomers yada yada
from
(select db1.tblcustomers)
but other than that...gotta ask some of the pros.
Edited by - jeffmetcalf on 03/24/2002 21:21:43
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
) and what I wanted to do is import the table from of them to the other overwritting everything on the other. The thing is that I want to do that with ASP, so I can automate that through a webpage... 
. I'll try to look for more info... 