Re: Spam Re: [Programmer-VB] Modifikasi tabel SQL

[skdmdn]

maksudnya di update gimana mas? ----- Original Message ----- From: Ronald Irawan To: Programmer-VB@yahoogroups.com Sent: Thursday, January 12, 2006 3:50 PM Subject: Spam Re: [Programmer-VB] Modifikasi tabel SQL Mungkin sebelum perintah alter tersebut, coba anda update colomn yang akan diubah tersebut menjadi hanya 20,.. Salam Ronald Irawan Pt. Sanghiang Perkasa Gd. Graha Kirana Lt.5 Jl Yos Sudarso Kav.88 Jakarta "skdmdn" <[EMAIL PROTECTED]> Sent by: Programmer-VB@yahoogroups.com 12/01/2006 02:29 PM Please respond to Programmer-VB@yahoogroups.com To <Programmer-VB@yahoogroups.com> cc Subject Re: [Programmer-VB] Modifikasi tabel SQL saya udah mencoba perintah di bawah untuk merubah column 20 menjadi 30 tapi klo saya coba merubah dari column 30 ke column 20 trus ada message Run-time error'String  or binary data would be truncated' FYI tabel tsb sudah berisi record2 Mohon bantuannya bagaimana caranya agar column tsb bisa di rubah. Thank's B4 ----- Original Message ----- From: Purwedi Kurniawan To: Programmer-VB@yahoogroups.com Sent: Monday, January 09, 2006 7:54 AM Subject: Re: [Programmer-VB] Modifikasi tabel SQL coba pake perintah ini   ALTER TABLE tablename ALTER COLUMN columnname NVARCHAR(30) best regards [wwn] On 1/8/06, skdmdn <[EMAIL PROTECTED]> wrote: Bisa gak field dalam tabel SQL dimodifikasi melalui Coding? Misalnya field nama panjang character  20, kemudian kita mau robah panjang character menjadi 30. Mohon dibantu ya temen2... Thank's B4 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. 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  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.