botax wrote:
>Fren, gimana cara bikin auto number di ms sql yah? ogut bikinnya pake
>enterprise manager.... dari listnya dah dicobaiin satu2 tapi kagak bisa tuh.
>Tolong dibantu yah.
>
>
Sewaktu "design" table, klik field yg tipe datanya Integer (atau variant
nya), terus lihat di sebelah bawah kan ada pilihan buat Identity.
Ini contoh SQL command waktu create table nya :
CREATE TABLE [Customers] (
[ID] [bigint] IDENTITY (1, 1) NOT NULL ,
[Name] [varchar] (30) NOT NULL
) ON [PRIMARY]
END
Coba lihat di Helpnya....keywordnya : IDENTITY
--
Best Regards,
Ferry Irawan
---
Arsip milis : http://groups.yahoo.com/group/toekangweb/messages
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toekangweb/
<*> 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/
