Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL(auto-increment)

Status
Not open for further replies.

discusmania

IS-IT--Management
Oct 24, 2000
158
AP
is there any auto-increment datatype? because i want to make my entry_ID automatically increase.

Thanks
 
Hi.

You have to set this field in SQL Server Enterprise Manager. Go to your database and go to the tables. Right click on the table and select Design Table.
- Check the Identity field.
- You can set the Identity Seed and Increment value too.


You can use command line too.

regards, Kirilla
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top