Bisa. Ato kalo mau lebih rapi :
strSQLCommand= "select * into table2 from tbtransaksi " & _
"go " & _
"drop table tbtransaksi"
cnn.execute strSQLCommand
Bisa juga pake 3x execute (tiap baris 1 execute, tapi berarti aplikasi
mengirimkan command ke server
3x - rasanya sih nggak terlalu ngurangin performance).
Sama aja dengan perintah kamu di bawah, tapi bacanya lebih enak (yg maintain
nanti juga nggak susah
bacanya.
Liung's
Frangky wrote:
>
>
> Mas Liung, yang anda maksudkan seperti dibawah ini?
>
> cnn.Execute "Select * into table2 from tbtransaksi go drop tbtransaksi"
>
> ----- Original Message -----
> From: "Liung Hartono" <[EMAIL PROTECTED]
> <mailto:Liungs%40pantarei-ad.com>>
> To: <[email protected] <mailto:Programmer-VB%40yahoogroups.com>>
> Sent: Tuesday, September 19, 2006 5:47 PM
> Subject: Re: [Programmer-VB] Bagaimana code vb untuk rename nama table SQL
> Server
>
> > Pakai select into. Mungkin ada cara lain yg langsung rename, tapi ini yg
> > saya tahu.
> > Select * into table2 from table1
> > go
> > drop table1
> >
> > PS : perintah go digunakan supaya perintah pertama dijalanin dulu sampai
> > selesai, baru perintah
> > kedua dijalankan. Kalo nggak pakai perintah go, takutnya perintah
> pertama
> > belom selesai, udah di
> > drop di perintah kedua.
> >
> > Liung's
> >
> > Frangky wrote:
> >>
> >>
> >> Teman-teman yang terhormat!
> >>
> >> Bagaimana code vb untuk rename nama table SQL Server?
> >>
> >>
> >
> >
> >
> > Wahana Programmer Groups Links
> >
> >
> >
> >
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
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/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/Programmer-VB/join
(Yahoo! ID required)
<*> To change settings via email:
mailto:[EMAIL PROTECTED]
mailto:[EMAIL PROTECTED]
<*> 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/
