[ITCENTER] Re: auto_increment di microsoft sql server 2000

[basroy]

berhasil mas, terima kasih.. ternyata cuman tambahin identity di field yang 
termasuk primary key nya :D 



--- In ITCENTER@yahoogroups.com, "Stereo..? Never..!" <djit...@...> wrote:
>
> auto_increment nya km ganti IDENTITY(24,1)
> 
> km hilangin
> ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci 
> AUTO_INCREMENT=24 ;
> kalo masih error manual saja , he2
> ===============================
> 
> " Ketika hidup harus memilih   "
> 
> ===============================
> 
> --- On Thu, 5/8/10, basroy <ceppyhasanb_ce...@...> wrote:
> 
> From: basroy <ceppyhasanb_ce...@...>
> Subject: [ITCENTER] auto_increment di microsoft sql server 2000
> To: ITCENTER@yahoogroups.com
> Date: Thursday, 5 August, 2010, 11:36 AM
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
>  
>  
> 
> 
> 
>   
> 
> 
>     
>       
>       
>       para master-master saya ada trouble dalam membuat database karena saya 
> baru belajar di dalam perkuliahan database ini. saya sebelumnya udah coba di 
> xampp dan berhasil tapi setelah saya pake di sql server 2000 kok ga bisa.
> 
> 
> 
> ini versi xampp-nya
> 
> 
> 
> CREATE TABLE IF NOT EXISTS `agenda` (
> 
>   `id_agenda` int(5) NOT NULL auto_increment,
> 
>   `tema` varchar(100) collate latin1_general_ci NOT NULL,
> 
>   `isi_agenda` text collate latin1_general_ci NOT NULL,
> 
>   `tempat` varchar(100) collate latin1_general_ci NOT NULL,
> 
>   `tgl_mulai` date NOT NULL,
> 
>   `tgl_selesai` date NOT NULL,
> 
>   `tgl_posting` date NOT NULL,
> 
>   `id_user` varchar(50) collate latin1_general_ci NOT NULL,
> 
>   PRIMARY KEY  (`id_agenda`)
> 
> ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci 
> AUTO_INCREMENT=24 ;
> 
> 
> 
> nah kodingan diatas setelah di coba di sql tersebut auto_increment nya kok ga 
> bisa ya. yang saya mau tanyakan kepada para master sekalian adalah letak 
> kesalahannya ada dimana, apakah ada kodingan lain selain auto_increment buat 
> pengisian id_agenda secara otomatis?
> 
> 
> 
> terima kasih
> 
> 
> 
> 
> 
>     
>      
> 
>     
>     
> 
> 
>  
> 
> 
> 
>   
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> [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/