|
metridim (m)
|
Hi Guys! please does anyone have an idea of how to generate Auto number in SQL 2000. The data type is Integer.
|
|
|
|
|
|
Kobojunkie
|
AutoNumber for a table?? Or just for calculations??
IDENTITY keyword is used
|
|
|
|
|
|
ThePhantom (m)
|
Create a column called "INDEX" (For Example only), change the data type to "INT". At the INDEX column details, select "Yes" for IDENTITY, make sure IDENTITY seed is 1 and IDENTITY Increment is 1. Now anytime you enter data in a row the INDEX colmnn will increase by 1.
|
|
|
|
|
|
metridim (m)
|
Thanks ThePhantom! I appreciate. One love!
|
|
|
|
|
|
Rheo
|
Housemate,
I need to learn MS SQL Server 2005 quickly to keep my job. Please can any housemate give me names of good training outfits and their address around Ikeja.
Thanks!
|
|
|
|
|
|
Kobojunkie
|
Logon every day to www.asp.net , Click on the LEARN Tab and watch and read lessons on how to use SQL 2005 and what it has to offer you. |
|
|
|
|
|
![Nairaland [Nigerian Forum] Home](http://www.nairaland.com/Themes/default/images/english/home.gif)
Author
