Article View: borland.public.interbase.sql
Article #1000Re: equivalent of RDB$DB_KEY in MS SQL Server?
From: Wayne Niddery [TeamB]
Date: Mon, 19 Feb 2007 16:17
Date: Mon, 19 Feb 2007 16:17
20 lines
2124 bytes
2124 bytes
Craig Stuntz [TeamB] wrote: > Bill Todd wrote: > >> I believe if you check BOL you will find that @@identity returns the >> last value that was assigned to an identity column for your >> connection, not the identity value for the current row. > > Also, it gives you a row ID, not a record version ID. I don't know if > there's any such thing as a record version ID in SQL Server 2005 and > of course older versions of SQL Server didn't do versioning at all. Thanks guys, obviously my caveat was well placed. <g> I thought @@Identity belonged to a row. -- Wayne Niddery - Winwright, Inc (www.winwright.ca) "We've all heard that a million monkeys banging on a million typewriters will eventually reproduce the entire works of Shakespeare. Now, thanks to the Internet, we know this is not true." - Robert Wilensky
Technical Details
Message-ID:
<45d9cd72$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!198.186.194.250.MISMATCH!transit3.readnews.com!news-out.readnews.com!panix!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<45d83499$1@newsgroups.borland.com> <45d8835a$1@newsgroups.borland.com> <45d8871b$1@newsgroups.borland.com> <45d8b10f$1@newsgroups.borland.com> <45d8deda$1@newsgroups.borland.com> <45d9ca96$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,a44ede0468b45c90 X-Google-Attributes: gid114a0e,public X-Google-Language: ENGLISH,ASCII-7-bit Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> Newsgroups: borland.public.interbase.sql References: <45d83499$1@newsgroups.borland.com> <45d8835a$1@newsgroups.borland.com> <45d8871b$1@newsgroups.borland.com> <45d8b10f$1@newsgroups.borland.com> <45d8deda$1@newsgroups.borland.com> <45d9ca96$1@newsgroups.borland.com> Subject: Re: equivalent of RDB$DB_KEY in MS SQL Server? Date: Mon, 19 Feb 2007 11:17:22 -0500 Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3028 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028 X-RFC2646: Format=Flowed; Original NNTP-Posting-Host: 69.17.170.228 Message-ID: <45d9cd72$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1171901810 69.17.170.228 (19 Feb 2007 08:16:50 -0800) Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!198.186.194.250.MISMATCH!transit3.readnews.com!news-out.readnews.com!panix!newsfeed.media.kyoto-u.ac.jp!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail