coba pake query berikut :
update databaseB
set Harga=a.harga
from databaseB
inner Join DatabaseA on a.kode=b.kode
quey ini akan Update semua harga di databaseB dengan Harga di DatabaseB
Semoga membantu
Arief
----- Original Message -----
From: antony
To: [email protected]
Sent: Sunday, March 25, 2007 2:36 AM
Subject: [indoprog-vb] cara update data....
salam,
ada yang tau gak ya cara update data dari database A ke database B.(struktur
databasenya sama,beda cuma data saja).
Misalnya saya cuma mau update harga saja dari tabel stock di database A ke
tabel Stock database B.
Databasenya memakai SQL Server 2000
---------------------------------
Need Mail bonding?
Go to the Yahoo! Mail Q&A for great tips from Yahoo! Answers users.
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
