I think a lot of people are going to reply on this but here goes...
4 is not the length but the amount of space that is allowed.
If it where a varchar or char then yes, only 4 characters could be added.
But it is 4 bytes and can store numbers from
-2,147,483,647 to 2,147,483,647. I suppose that you might run into a problem
if you have more than 2.1 billion records on that table.
Mike Bruce
Fig Leaf Software
-----Original Message-----
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 12:32 PM
To: CF-Talk
Subject: RE: OT SQL Server (OK 1 More ?)
OK I got it. Now that I have the primary key set with datatype int, the
length is limited to 4. Is this correct and will this limit the table to
9999 records?
Thanks,
Rich
-----Original Message-----
From: Craig Bowes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 11:30 AM
To: CF-Talk
Subject: RE: OT SQL Server
You must set a field to be identity and not null. You can set its seed to
any number (start autonumbering at 1000 for example.)
-----Original Message-----
From: ibtoad [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 13, 2001 9:37 AM
To: CF-Talk
Subject: OT SQL Server
I have a simple question. How do you set the primary key field to
autonumber in SQL server? I have always used Access where this is a choice
but don't see how to do it with SQL Server 2000.
Thanks,
Rich
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists