INi SQL Server apa yah? kalau SQL salah satu caranya adalah
begin tran ron
'Buat tabel temporay untuk nampung data nya
create table #tampung( id int null,
th char(4) null,
bln int)
insert into #temp select distinct id,th,bln from tableASLInya
'Data yg tdk double sdh ada di temporary table, kemudian hapus data di table aslinya,
truncate table TABLEAslinya
'Insert dari table tampung nya
Insert into TABLEASLINYA(id,th,bln) select * from #tampung
drop table #tampung
rollback tran ron
'Kalau hasilnya sdh sesuai harapan, maka rollback nya ganti jadi commit
Salam
Ronald Irawan
Pt. Sanghiang Perkasa
Gd. Graha Kirana Lt.5
Jl Yos Sudarso Kav.88
Jakarta
| Djoko <[EMAIL PROTECTED]>
Sent by: [email protected] 07/06/2006 07:04 PM
|
|
Seniorz... SOS nehh
kejadiannya spt ini :
Admin melakukan eksekusi file sql dua kali. Yang terjadi kemudian banyak
data yg double menambah ke db. Contohnya begini :
id th bln
1 2002 1
1 2002 2
1 2002 3
1 2002 3
1 2002 4
1 2002 4
1 2002 5
1 2002 5
Bagamana cara aku dapat hapus data hanya yg double saja?.. sama persis
bozz gak ada field yg membedakan. hingga nanti maunya spt ini :
1 2002 1
1 2002 2
1 2002 3
1 2002 4
1 2002 5
Matur nuwun ....kalo bisa querry yg simplest yaa.. recordnya 6 digits nehh
JK
------------------------ Yahoo! Groups Sponsor --------------------~-->
Great things are happening at Yahoo! Groups. See the new email design.
http://us.click.yahoo.com/TISQkA/hOaOAA/yQLSAA/k7folB/TM
--------------------------------------------------------------------~->
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Programmer-VB/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
__._,_.___
Wahana Programmer Groups Links
<*> Untuk mengunjungi sponsor milis ini, klik link berikut:
http://wahanaprogrammer.net
<*> Untuk menghubungi owner milis ini, kirim email ke:
[EMAIL PROTECTED]
<*> Konsultasi pemrogramman bisa chat disini:
Yahoo! Messenger: wahanaprogrammer
SPONSORED LINKS
| Programmer | Indonesia | Basic programming language |
| Computer programming languages | Programming languages | Java programming language |
YAHOO! GROUPS LINKS
- Visit your group "Programmer-VB" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
