Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Autonumber equivalent in SQL Server
Message
From
24/03/2003 11:28:57
 
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00768911
Message ID:
00769291
Views:
26
You're welcome.

>Thanks, Sergey!
>
>>You can use numeric datatype (int, bigint, numeric, e.t.c) column with IDENTITY property.
>>
>>>I have often used the autonumber data type in Access and have created stored procedures in the default value to autoincrement in VFP. I need to accomplish the same thing in SQL server, but have little TSQL knowledge and can't find any canned ways to autonumber an inserted record for a primary key.
>>>
>>>Anybody know the preferred way to accomplish this in SQL server? Any examples would be most helpful.
>>>
>>>Thanks!
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform