ganti :
*`id_agenda` int(5) NOT NULL auto_increment*
menjadi
* `id_agenda`** smallint IDENTITY(1,1)PRIMARY KEY CLUSTERED*
baca juga lebih detail auto increment di sql server 2000 karena berbeda
dengan mysql
http://msdn.microsoft.com/en-us/library/Aa933196
2010/8/5 basroy <[email protected]>
>
>
> 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 : [email protected]
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:
[email protected]
[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/
