Database Discussion - Autonumber

Print Page | Close Window

Autonumber

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Database Discussion
Forum Description: Discussion and chat on database related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3361
Printed Date: 29 March 2026 at 10:54pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Autonumber

Posted By: Gullanian
Subject: Autonumber
Date Posted: 07 June 2003 at 1:50pm

Can anyone explain how to create the autonumber effect in ms SQL?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 07 June 2003 at 1:57pm

It's called indentity, and you set the number it jumps by so set it as 1 if you want, 1,2,3, etc. as your autonumbers.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: Gullanian
Date Posted: 07 June 2003 at 2:04pm

sorry for being a thicko, by identity do you mean datatype or name of autonumber

Posted By: Gullanian
Date Posted: 07 June 2003 at 4:24pm

Ok I got it cheers! Didnt know what you meant by identity, its in the field properties box

cheers