SQL does not have autonumber, but you can set the field to Identity, then
set the Identity seed and Identity increment to whatever you wish. (Seed is
your start number, increment, well, that should be obvious.
Rich sat down, thought things over, and said....
~~~~~~~~~~
I have a simple question. How do you set the primary key field to
autonumber in SQL server? I have always used Access where this is a choice
but don't see how to do it with SQL Server 2000.
Thanks,
Rich
~~~~~~~~~~
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
