In SQL Server Enterprise Manager you select type "integer", uncheck the box
for "allow NULLs" and check the box for "identity". You can optionally set
"identity seed" to set a starting number and "identity increment" so that
numbers are incremented by whatever you specify (default for both options is
1).
_____________________________________________________
Kay Smoljak - ColdFusion Developer - PerthWeb Pty Ltd
Internet Solutions for your business!
Level 9/105 St George's Tc - Perth - Western Australia
Ph: (08) 9226 1366 Fax: (08) 9226 1375 Mobile : 0419 949 007
Visit Perth online! : www.perthweb.com.au
Tools for Developers including CFX tags: http://developer.perthweb.com.au
On Mon, 02 Apr 2001 10:05:20 -0400, "Tumy, Brad" <[EMAIL PROTECTED]>
wrote:
>In the design view of a table you can select the field called "identity"
>....I believe that this will do the trick...I am new to SQL Server so if
>anyone can follow up to correct me or to clarify in more depth.
>
>Brad Tumy
>
>-----Original Message-----
>From: Arden Weiss [mailto:[EMAIL PROTECTED]]
>Sent: Monday, April 02, 2001 9:58 AM
>To: CF-Talk
>Subject: RE: [Oracle Auto-Increment]
>
>
>What about SQL Server -- how to auto-increment??
>
> ^
> / \__
> ( @\___
> / O
> / (_____/
>/_____/
>Whoof...
>410-757-3487
>
>-----Original Message-----
>From: Alex [SMTP:[EMAIL PROTECTED]]
>Sent: Monday, April 02, 2001 9:45 AM
>To: CF-Talk
>Subject: Re: [Oracle Auto-Increment]
>
>create a sequence then in your INSERT sql type sequencenqme.next_val.
>not sure on specific syntax
>
>Jamie Symonds <[EMAIL PROTECTED]> wrote:
>Hi - I am inserting results of a form into an Oracle 8
>database - in the past, while using Access, I would set the
>first field of the table ("id") to "auto-number" for my
>primary key. Oracle does not have an auto-increment feature
>- how do I go about this? Thanks.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
