[thelist] SQL basic questions

rudy r937 at interlog.com
Tue Jan 22 05:47:56 CST 2002

> How would you do this in MS SQL?


i'm sorry, ted, i mistakenly read your original question as mysql

joel had the create part --

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

now the secret for sql/server is that you *don't* mention the identity key
when you insert a row --

   insert into foo (foodata)
      values ('bar')

easy, eh?

it's almost like inserting a null   ;o)


More information about the thelist mailing list