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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
