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/
