Autonumber

Sorry if this is a dumb question, but I am new to SQL Server.
Does the ability exist if SQL to specify a field as type "Autonumber" as you
can when designing Access tables, or does it all have to be done
programatically?
ThanksKeith,
You can use the IDENTITY property. Do please check it in Books OnLine if it
suits you.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Keith" <@..> wrote in message news:eYmqNlPBEHA.916@.tk2msftngp13.phx.gbl...
> Sorry if this is a dumb question, but I am new to SQL Server.
> Does the ability exist if SQL to specify a field as type "Autonumber" as
you
> can when designing Access tables, or does it all have to be done
> programatically?
> Thanks
>|||Keith,
Read in Books Online about the "identity" property.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Keith" <@..> wrote in message news:eYmqNlPBEHA.916@.tk2msftngp13.phx.gbl...
> Sorry if this is a dumb question, but I am new to SQL Server.
> Does the ability exist if SQL to specify a field as type "Autonumber" as
you
> can when designing Access tables, or does it all have to be done
> programatically?
> Thanks
>|||Keith
No, It does not, instead you have IDENTITY property with the same behaviour.
For more details please refer to the BOL.
"Keith" <@..> wrote in message news:eYmqNlPBEHA.916@.tk2msftngp13.phx.gbl...
> Sorry if this is a dumb question, but I am new to SQL Server.
> Does the ability exist if SQL to specify a field as type "Autonumber" as
you
> can when designing Access tables, or does it all have to be done
> programatically?
> Thanks
>|||Thank you
That works fine
"Keith" <@..> wrote in message news:eYmqNlPBEHA.916@.tk2msftngp13.phx.gbl...
> Sorry if this is a dumb question, but I am new to SQL Server.
> Does the ability exist if SQL to specify a field as type "Autonumber" as
you
> can when designing Access tables, or does it all have to be done
> programatically?
> Thanks
>