Mas Liung, kalau saya pakai code ini:
cnn.Execute "Select * into table2 from tbtransaksi go drop tbtransaksi"

muncul pesan error:

Run-time error '-2147467259 (80004005)
Methode 'Execute' of object'_Connection' failed


----- Original Message ----- 
From: "Liung Hartono" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, September 20, 2006 9:20 AM
Subject: Re: [Programmer-VB] Bagaimana code vb untuk rename nama table SQL 
Server


> 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
>
>
>
>
> 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/
 


Kirim email ke