Re: [ITCENTER] edit tabel di sql 2008

2013-06-17 Terurut Topik Barst Mendas
Dear Taufik,

Biasanya kalau pake SQL Server Management Studio kemungkinan gagal jika 
mengubah field yang sudah ada atau pun meng-insert field baru diantara field 
yang sudah ada.
Tapi apakah sudah dicoba menggunakan script ALTER TABLE ?

Saya biasanya pakai script ALTER TABLE jika menggunakan SSMSgagal.

Script ALTER bisa banyak ditemukan menggunakan Google SE (tergantung kebutuhan 
alter nya bagaimana)

Mohon maaf jika kurang membantu.

Regards,
Barst Mendas S





 From: Taufik 
To: ITCENTER@yahoogroups.com 
Sent: Thursday, June 13, 2013 12:58 PM
Subject: [ITCENTER] edit tabel di sql 2008
 


  
Dear all,
gmn caranya edit tabel kalo pke sql 2008 tnpa mendelete tabel itu dlu..soalnya 
ane coba berkali2 gagal disave trs..

thx


 

[Non-text portions of this message have been removed]





-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : itcenter-h...@yahoogroups.com 

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

<*> To change settings via email:
itcenter-dig...@yahoogroups.com 
itcenter-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
itcenter-unsubscr...@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/



Re: [ITCENTER] edit tabel di sql 2008

2013-06-17 Terurut Topik Donny DS
Om,
coba pakai heidy sql
lebih gampang..

Donny NetLErp
Web database programmer

On 13-06-2013 12:58, Taufik wrote:
>
> Dear all,
> gmn caranya edit tabel kalo pke sql 2008 tnpa mendelete tabel itu 
> dlu..soalnya ane coba berkali2 gagal disave trs..
>
> thx
>
> 



[Non-text portions of this message have been removed]





-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : itcenter-h...@yahoogroups.com 

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

<*> To change settings via email:
itcenter-dig...@yahoogroups.com 
itcenter-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
itcenter-unsubscr...@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/



Re: [ITCENTER] edit tabel di sql 2008

2013-06-17 Terurut Topik mardaud_parwinoto
Dear Taufik,

Harusnya tidak ada masalah... tapi kalau tetap tidak bisa di-edit (strange 
case) berarti memang harus buat tabel baru, tapi jangan lupa di backup 
dulu data-data di tabel lamanya.

Btw, field yang agan edit/update buka primary key ataupun foreign key kan?

Regards,
Mr_Daud



From:   "Taufik" 
To: ITCENTER@yahoogroups.com
Date:   13/06/2013 13:23
Subject:    [ITCENTER] edit tabel di sql 2008
Sent by:ITCENTER@yahoogroups.com



 
Dear all,
gmn caranya edit tabel kalo pke sql 2008 tnpa mendelete tabel itu 
dlu..soalnya ane coba berkali2 gagal disave trs..

thx



__
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
__

[Non-text portions of this message have been removed]





-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : itcenter-h...@yahoogroups.com 

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

<*> To change settings via email:
itcenter-dig...@yahoogroups.com 
itcenter-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
itcenter-unsubscr...@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/



[ITCENTER] edit tabel di sql 2008

2013-06-12 Terurut Topik Taufik
Dear all,
gmn caranya edit tabel kalo pke sql 2008 tnpa mendelete tabel itu dlu..soalnya 
ane coba berkali2 gagal disave trs..


thx





-- 
www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia 
Gabung, Keluar, Mode Kirim : itcenter-h...@yahoogroups.com 

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/ITCENTER/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/ITCENTER/join
(Yahoo! ID required)

<*> To change settings via email:
itcenter-dig...@yahoogroups.com 
itcenter-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
itcenter-unsubscr...@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/