At 07:42 AM 6/7/2002 +0300, you wrote:
Hello !

I have try to make such a field to the database which grows automatically
when I insert information to database. How can I make such a field ?
I have before SQL Server 7.0 and access 97/2000 and there it is really easy
to make.

Do you mean Auto Increment field?
If yes, you can use sequence

CREATE SEQUENCE  OWNER.SEQNAME
[INCREMENT BY <integer>
[START WITH <integer>]
[MAXVALUE <integer> | NOMAXVALUE]
[MINVALUE <integer> | NOMINVALUE]
[CYCLE | NOCYCLE]
[CACHE <
unsigned_integer > | NOCACHE]
[ORDER | NOORDER]

Reply via email to