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: [email protected] 12/01/2006 02:29 PM
|
|
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: [email protected]
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
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.
