Friday, February 10, 2012

autonumber in SQL Server Express

Does anyone know how to add an autonumber field into a table? Is this the same as uniqueidentifier? I have a table and I need to create a field to use as Primary Key. I would appreciate any help.

-Brad B

identity is the autonumber keyword.

create table tblWhatever

(

id int identity,

name nvarchar(50) /* whatever */

)

|||Ok... I'm going to give that a try! Thanks Chris.

No comments:

Post a Comment