Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / NewStats: 3,154,193 members, 7,822,021 topics. Date: Thursday, 09 May 2024 at 01:56 AM |
Nairaland Forum / Science/Technology / Programming / Sql 2000 Need Help (937 Views)
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)
Sql 2000 Need Help by metridim(m): 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(m): 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. |
(1) (Reply)
How Much Are They Paying / Help Pls! / How To Use Div?
(Go Up)
Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health religion celebs tv-movies music-radio literature webmasters programming techmarket Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10) Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 7 |