You must set a field to be identity and not null. You can set its seed to
any number (start autonumbering at 1000 for example.)
-----Original Message-----
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 9:37 AM
To: CF-Talk
Subject: OT SQL Server
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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
