That means 4 bytes. This will limit the number but more like around 30,000.
I don't remember the exact number, anyone...?
Derek
----- Original Message -----
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 9:32 AM
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
