Web Wiz Support and Community Forums : MSSQL identity field for unique ID numbers https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 08 Apr 2026 14:00:22 +0000 Wed, 29 Nov 2006 22:56:23 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=22064 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[MSSQL identity field for unique ID numbers : Thanks for the follow up. I tried...]]> https://forums.webwiz.net/mssql-identity-field-for-unique-id-numbers_topic22064_post117702.html#117702 Author: bikeweb
Subject: 22064
Posted: 29 November 2006 at 10:56pm

Thanks for the follow up.  I tried to google the answer myself and I wasn't getting anywhere.  I knew that the fields couldn't be that limited.]]> Wed, 29 Nov 2006 22:56:23 +0000 https://forums.webwiz.net/mssql-identity-field-for-unique-id-numbers_topic22064_post117702.html#117702 <![CDATA[MSSQL identity field for unique ID numbers : INT&#039;s are stored in binary...]]> https://forums.webwiz.net/mssql-identity-field-for-unique-id-numbers_topic22064_post117701.html#117701 Author: michael
Subject: 22064
Posted: 29 November 2006 at 10:49pm

INT's are stored in binary and not as a string, so 4 is enough. INT can hold anything between -2^31 (-2,147,483,648) through 2^31 -
1 (2,147,483,647) that should give you enough room for now.]]> Wed, 29 Nov 2006 22:49:37 +0000 https://forums.webwiz.net/mssql-identity-field-for-unique-id-numbers_topic22064_post117701.html#117701 <![CDATA[MSSQL identity field for unique ID numbers : I&#039;m posting this question...]]> https://forums.webwiz.net/mssql-identity-field-for-unique-id-numbers_topic22064_post117698.html#117698 Author: bikeweb
Subject: 22064
Posted: 29 November 2006 at 8:09pm

I'm posting this question again since nobody anwered the question the last time I posted it but I'll try and rephrase the question.
 
With a MSSQL database, to assign a unique ID number to a field item.  WWF uses the "int" Type with a length of 4, the nullable column is unchecked, the Id column is checked, start and Id seed are set to to 1,1.
 
I have several fields in my own database that use this same method.
 
My question is this:
 
Because the length is 4 does this mean that the total entries can only be up to 9999?  What if I have a database with more than 10,000 entries in this field?  Is the WWF limited to this many entries?
 
I'm worried about using this method and also using WWF for my project if this is the case.
 
I've already purchased a license.
 
Thanks
]]> Wed, 29 Nov 2006 20:09:33 +0000 https://forums.webwiz.net/mssql-identity-field-for-unique-id-numbers_topic22064_post117698.html#117698