[thelist] SQL basic questions

[rudy]

> How would you do this in MS SQL?

DOH!

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)


rudy