Sql 2000 Need Help - Programming - Nairaland
Nairaland Forum › Science/Technology › Programming › Sql 2000 Need Help (1027 Views)
| Sql 2000 Need Help by metridim(op): 3:30pm On Feb 09, 2008 |
Hi Guys! pls does anyone have an idea of how to generate Auto number in SQL 2000. The data type is Integer. |
| Re: Sql 2000 Need Help by Kobojunkie: 5:36pm On Feb 09, 2008 |
AutoNumber for a table?? Or just for calculations?? IDENTITY keyword is used |
| Re: Sql 2000 Need Help by ThePhantom(m): 11:17pm On Feb 10, 2008 |
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. |
| Re: Sql 2000 Need Help by metridim(op): 11:00am On Feb 11, 2008 |
Thanks ThePhantom! I appreciate. One love! |
| Re: Sql 2000 Need Help by Rheo: 2:23pm On Feb 21, 2008 |
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! |
| Re: Sql 2000 Need Help by Kobojunkie: 3:44pm On Feb 21, 2008 |
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. |
Help!!! Login Failed For User in SQL Server • How To Connect Vb.net Windows Application To Php And My Sql Database • Oracle Vs Sql Server • 2 • 3 • 4
Excel Gurus, Please Help Me On This Problem Asap - - - - • Social Im Sites That Can Connect You To Facebook • I Wan Learn Php Oh!