http://www.programmersheaven.com/ Contains the latest posts from the thread 'Auto-number' posted on the 'SQL-Server' forum at Programmer's Heaven. en Copyright 2013 Programmers Heaven Fri, 24 May 2013 19:45:59 -0700 Fri, 24 May 2013 19:45:59 -0700 Argotic Syndication Framework 2007.3.0.1, http://www.codeplex.com/Argotic http://www.rssboard.org/rss-specification 360 http://www.programmersheaven.com/images/ph.gif http://www.programmersheaven.com/ 88 31 http://www.programmersheaven.com/mb/sql-server/205432/205432/auto-number/ Does the Microsoft SQL server 2000 got data types auto-number like microsoft access?<br /> http://www.programmersheaven.com/mb/sql-server/205432/205432/auto-number/ Wed, 06 Aug 2003 07:27:35 -0700 SQL-Server http://www.programmersheaven.com/mb/sql-server/205432/205528/re-auto-number/#205528 Sure does, but it's not called an "Auto-Number" any more. Make the Field type a long, int whatever, and set the Identity to yes. Then set the Identity seed to 1 as well as the Identity Incrament = 1. That should do it.<br /> <br /> Peace<br /> -N473<br /> <br /> <hr /><br /> : Does the Microsoft SQL server 2000 got data types auto-number like microsoft access?<br /> : <br /> <br /> http://www.programmersheaven.com/mb/sql-server/205432/205528/re-auto-number/#205528 Wed, 06 Aug 2003 14:27:19 -0700 SQL-Server http://www.programmersheaven.com/mb/sql-server/205432/205609/re-auto-number/#205609 Thankz for ur help man<br /> <br /> http://www.programmersheaven.com/mb/sql-server/205432/205609/re-auto-number/#205609 Thu, 07 Aug 2003 00:04:31 -0700 SQL-Server