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!

Register Log in
  • 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 Server & Autonumber

Status
Not open for further replies.
glove

glove

Technical User
Aug 24, 2000
42
US
I have imported some tables from an Access 2000 database onto an SQL Server. Some of the fields in the tables had an autonumber format, however SQL Server converted them to a number format. Does SQL Server not support autonumber? [sig][/sig]
 
Sort by date Sort by votes
SQL Server does not have an explicit &quot;autonumber&quot; format. Integers are typically used for Identity-type columns, which is the closest thing I can think of to AutoNumber. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href= - Visual FoxPro Development</a><br> [/sig]
 
Upvote 0 Downvote
SQL Server does have the auto number functionality. It is called Identity. [sig]<p>John A. Gilman<br><a href=mailto:gms@uslink.net>gms@uslink.net</a><br>[/sig]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
620
Volvere
V
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
708
pjw001
pjw001
Steve Yu
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
331
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
417
Mike Lewis
Mike Lewis
grnzbra
  • Locked
  • Question
T-SQL Dialog Box
Replies
8
Views
410
Chris Miller
Chris Miller

Part and Inventory Search

Sponsor

Back
Top