settings primary key in managemtn studio SQL2008

christopher

Member
Joined
Feb 2, 2012
Messages
8
Programming Experience
5-10
Im new in sql server 2008 , new to sql actually :) always used access databases.
so ive created a table, set a primary key, now my problem is when i add rows to this database
it doesnt autmaticly make a numeric ID, just says field cannot be NULL wich ive set it to be.
how do i make it autincrement a numeric ID on row creation ?
pic to show current settings
thanks for your time and help.

sql.png
 
You have to set Identity to Yes.
 
Back
Top