<CF_IGNORE User="Mike Connolly">
<CFX_TALKINGARSE User="Mike Connolly">
<CFABORT>
> -----Original Message-----
> From: Mike Connolly [SMTP:[EMAIL PROTECTED]]
> Sent: 16 October 2000 14:36
> To: CF-Talk
> Subject: RE: SQL Server -> MS Access "Autonumber"?
>
> I believe autonumbering is bad practice in world of data-integrity.
>
> You will find that when creating tables in SQL there is not an equivalent
> to
> Autonumbering for a field.
>
> However I'm pretty sure you can replicate this using a stored procedure or
> trigger?
>
> > -----Original Message-----
> > From: cf kaizen [SMTP:[EMAIL PROTECTED]]
> > Sent: 16 October 2000 14:27
> > To: CF-Talk
> > Subject: OT: SQL Server -> MS Access "Autonumber"?
> >
> > Hi,
> >
> > Forgive my newbiness. Is there an SQL equivalent to MS
> > Access' AutoNumber type field? I just "upgraded" an
> > Access db to SQL Server, and the Autonumber field
> > comes across as "int". Is there any way to
> > automatically increment this and continue to use it as
> > the PK, or is this bad practice to begin with?
> >
> > TIA,
> > Andy
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Messenger - Talk while you surf! It's FREE.
> > http://im.yahoo.com/
> >
> --------------------------------------------------------------------------
> > ----
> > Archives: http://www.mail-archive.com/[email protected]/
> > To Unsubscribe visit
> > http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk
> or
> > send a message to [EMAIL PROTECTED] with 'unsubscribe'
> in
> > the body.
>
>
> -----------------------------------------------
> Any opinions expressed in this message are those of the individual and not
> necessarily the company. This message and any files transmitted with it
> are confidential and solely for the use of the intended recipient. If you
> are not the intended recipient or the person responsible for delivering to
> the intended recipient, be advised that you have received this message in
> error and that any use is strictly prohibited.
>
> Sapphire Technologies Ltd
> http://www.sapphire.net
> --------------------------------------------------------------------------
> ----
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
-----------------------------------------------
Any opinions expressed in this message are those of the individual and not necessarily
the company. This message and any files transmitted with it are confidential and
solely for the use of the intended recipient. If you are not the intended recipient
or the person responsible for delivering to the intended recipient, be advised that
you have received this message in error and that any use is strictly prohibited.
Sapphire Technologies Ltd
http://www.sapphire.net
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
