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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
