Article View: borland.public.interbase.sql
Article #999Re: equivalent of RDB$DB_KEY in MS SQL Server?
From: Craig Stuntz TeamB
Date: Mon, 19 Feb 2007 16:04
Date: Mon, 19 Feb 2007 16:04
15 lines
1954 bytes
1954 bytes
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. -- Craig Stuntz [TeamB] � Vertex Systems Corp. � Columbus, OH Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz Useful articles about InterBase development: http://blogs.teamb.com/craigstuntz/category/21.aspx
Technical Details
Message-ID:
<45d9ca96$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!news.albasani.net!feeder06.uucp-net.de!reader.uucp.at!newsfeed.uucp.at!news.uucp.at!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>Show Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,a44ede0468b45c90 X-Google-Attributes: gid114a0e,public X-Google-Language: ENGLISH,ASCII From: "Craig Stuntz [TeamB]" <craig_stuntz@nospam.please [a.k.a. acm.org]> Subject: Re: equivalent of RDB$DB_KEY in MS SQL Server? 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> Organization: Vertex Systems Corporation User-Agent: XanaNews/1.18.1.5 X-Face: "huzh55Xi]!ZNni78>a*5+).`SK?<^q2MlHk-C]Z2M9T@\J5ZCB$95Ey+s"XQuhGFA[eutZ:0^AV!Q;t>gE`1-=8d;HZ6~*o1dH<X9\b$!|(}+I'!Xq)@3Op}%0ArW&nf'Qh*EwR MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit NNTP-Posting-Host: 24.106.104.205 Message-ID: <45d9ca96$1@newsgroups.borland.com> Date: 19 Feb 2007 08:04:38 -0800 X-Trace: newsgroups.borland.com 1171901078 24.106.104.205 (19 Feb 2007 08:04:38 -0800) Lines: 15 X-Authenticated-User: cstuntz Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!news.albasani.net!feeder06.uucp-net.de!reader.uucp.at!newsfeed.uucp.at!news.uucp.at!newsgroups.borland.com!not-for-mail