Thanks man! >From: "Maia, Eric" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: SQL <[EMAIL PROTECTED]> >Subject: RE: autonumber >Date: Fri, 2 Nov 2001 13:55:53 -0800 > >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? > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
