> so an example would be > > create table foo > ( fookey int not null auto_increment > , foodata varchar(20) null) > > insert into foo (fookey, foodata) > values (null, 'bar') How would you do this in MS SQL? I can't find this anywhere in the docs. Only info on INDEX which is some 16 bit hex code value. I just want like 1, 2, 3, 4, ect. Thanks ted