In MS SQL Server, use Group_id int identity (1,1) not null
Eric -----Original Message----- From: imogenkhan imogenkhan [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 1:52 PM To: SQL Subject: autonumber I'm trying to create a table in MS SQL Server: CREATE TABLE OPTgroups ( Group_id auto, Organizer varchar(50) NOT NULL, Group_name varchar(50) NOT NULL, Group_number varchar(4) NOT NULL, Flight1 varchar(4), Flight2 varchar(4), CONSTRAINT group_id PRIMARY KEY (group_id) ) I'm trying to make Group_id an autonumber that will automatically populate with every new record thats inserted. But I keep getting Server: Msg 2715, Level 16, State 7, Line 1 Column or parameter #1: Cannot find data type auto. How do I remedy this? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
