[thelist] SQL basic questions

[Joshua Olson]

----- Original Message ----- 
From: "ted serbinski" <tss24 at cornell.edu>
Subject: RE: [thelist] SQL basic questions



: 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

MSSQL example

create table foo
(fookey numeric(9) IDENTITY PRIMARY KEY,
 foodata varchar(20) null)

HTH,

-joshua