Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

autoincrement

4 posts in Windows NT Last posting was on 1999-12-26 10:29:43.0Z
Harry Kalogiroy Posted on 1999-12-24 20:33:56.0Z
From: "Harry Kalogiroy" <harkal@rainbow.cs.unipi.gr>
Subject: autoincrement
Date: Fri, 24 Dec 1999 22:33:56 +0200
Lines: 7
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <wgmd56kT$GA.191@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ppp125.lar.forthnet.gr 193.92.104.216
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2774
Article PK: 1090211

how can I implement a default that does what the autoincrement default
does at adaptive server anywhere?

thanks
Harry Kalogirou


Rob Verschoor Posted on 1999-12-25 12:39:06.0Z
From: "Rob Verschoor" <rob@sypron.nl>
References: <wgmd56kT$GA.191@forums.sybase.com>
Subject: Re: autoincrement
Date: Sat, 25 Dec 1999 13:39:06 +0100
Lines: 29
Organization: Sypron B.V.
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <xE51QLvT$GA.299@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: p730.asi.euronet.nl 194.134.124.222
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2773
Article PK: 1090209

You can use an "identity column". Best read this story for some background
on potential problems : http://www.euronet.nl/~syp_rob/idgaps.html

HTH,

Rob

--
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase ASE 11.5 Administrator (Professional)
Certified DBA/Performance & Tuning Specialist for Sybase System 11

email mailto:rob@sypron.nl.*No*Spam*Please*
WWW http://www.euronet.nl/~syp_rob
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------

Harry Kalogiroy wrote in message ...
>how can I implement a default that does what the autoincrement default
>does at adaptive server anywhere?
>
>thanks
>Harry Kalogirou
>
>


Harry Kalogiroy Posted on 1999-12-25 22:22:13.0Z
From: "Harry Kalogiroy" <harkal@rainbow.cs.unipi.gr>
References: <wgmd56kT$GA.191@forums.sybase.com> <xE51QLvT$GA.299@forums.sybase.com>
Subject: Re: autoincrement
Date: Sun, 26 Dec 1999 00:22:13 +0200
Lines: 6
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <iOsyGcyT$GA.299@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ppp115.lar.forthnet.gr 193.92.104.206
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2772
Article PK: 1090212

I just need a simple autoincrement... Anything more complicated wont do :(

Harry Kalogirou


Rob Verschoor Posted on 1999-12-26 10:29:43.0Z
From: "Rob Verschoor" <rob@sypron.nl>
References: <wgmd56kT$GA.191@forums.sybase.com> <xE51QLvT$GA.299@forums.sybase.com> <iOsyGcyT$GA.299@forums.sybase.com>
Subject: Re: autoincrement
Date: Sun, 26 Dec 1999 11:29:43 +0100
Lines: 18
Organization: Sypron B.V.
X-Newsreader: Microsoft Outlook Express 4.71.1712.3
X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3
Message-ID: <Ty4Qmy4T$GA.299@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: p1231.asi.euronet.nl 194.134.8.31
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2771
Article PK: 1090206

"identity columns" is the only available "autoincrement" in ASE. The basic
use is *very* simple. Depending on what you want to use it for, you may need
to pay attention to certain issues.

HTH,

Rob

Harry Kalogiroy wrote in message ...
>I just need a simple autoincrement... Anything more complicated wont do :(
>
>Harry Kalogirou
>
>
>