TSQL and Autogenerate **SOLVED**

[Sgt-Peppa]

Hi all, I am pretty new to that TSQL thingy. Herers one thing I just cant seem to find an answer on the net!
I use MS SQL Server 2000.
This is what I do to create a new Table:

CREATE TABLE blah
(
blahId integer Primary Key Not Null,
myText varchar(50)
)
Go

This works fine. But I want to tell the SQLServer that the blahId will be autogenerated by the Database. What would I need to include in my script. I tried generate and autogenerate but both dont seem to work!

Also how would my insert Statement look like.
Usually you would like this:

INSERT INTO blah VALUES (NULL,'someText')

Will that still work?

Thanks,

Stephan