Make sure that your @@identity query is immediately following your
insert, otherwise, you can get some pretty strange results.
HTH
Brian
----- Original Message -----
From: Neil H. <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Saturday, October 07, 2000 12:29 AM
Subject: Craziest damn thing with @@identity.
> I only have one identity column (that I Know of and I am pretty sure I
know)
> in this table. Yet when I query our @@Identity I get a weird number.
I
> Don't know where it comes from and I verified the dbcc checkident and
it
> gives me the number I was looking for? Any ideas.
>
> Thanks,
>
> Neil
>
> -----------------------------------------------------------------------
-------
> 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.
>
------------------------------------------------------------------------------
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.
