sql server syntax is group_id int identity not null
Travis ---- Original Message ---- From: imogenkhan imogenkhan <[EMAIL PROTECTED]> Sent: 2001-11-02 14:51:43.0 To: SQL <[EMAIL PROTECTED]> 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? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
