IDENTITY Column Insert

From: payyans (payyans_at_discussions.microsoft.com)
Date: 01/13/05 

Date: Wed, 12 Jan 2005 20:43:01 -0800

Hi,
Version: SQL Server 2000 Standarad Edition.
---------------------------------------------------
Does SQL Server Insert value to the IDENTITY column in one action, or does
it INSERT other columns of the table and UPDATE the IDENTITY column as a
separate statement, internally?

If I issue an independent SELECT WITH NOLOCK on such a table, is there a
possibility of getting wrong value for the Identity column anytime?
Thanks,
payyans

Relevant Pages

  • HELP: Dropped table column causes sp_addmergearticle to fail with replication
    ... I'm setting up merge replication on sql server 2000 sp3. ... there is no identity column in this table ... The article 'tkDPLRS' could not be added to the publication 'TEST1'. ...
    (microsoft.public.sqlserver.replication)
  • Re: How to insert auto increment?
    ... And there are no other column involved except IDENTITY column. ... single row will do the same thing). ... INSERT INTO tbl DEFAULT VALUES; ... State what version of SQL Server you are using and specify the content ...
    (microsoft.public.sqlserver.mseq)
  • RE: IDENTITY Column Insert
    ... decremented and you will find 'holes' in the sequences. ... "payyans" wrote: ... SQL Server 2000 Standarad Edition. ... > Does SQL Server Insert value to the IDENTITY column in one action, ...
    (microsoft.public.sqlserver.server)
  • Re: @@Identity
    ... How Does SQL Server Manage Identity Values? ... When you add a row to a table with an Identity column you don't include a ... A scope is a module -- a stored procedure, trigger, function, or ... > If you are inserting a row with your ADO.Net code that will increment the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: cluster index and identity
    ... Hot spotting data gives the cache manager something to grab hold of. ... Clustering on a narrow unique key also has benefits, ... I do not use the identity column as my Primary Key. ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)