Re: Identity

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 11/03/04 

Date: Wed, 3 Nov 2004 10:04:36 -0500

http://www.aspfaq.com/2237 

-- 
http://www.aspfaq.com/
(Reverse address to reply.)
"Sri" <Sri@discussions.microsoft.com> wrote in message
news:41EFE7DF-6803-430E-BE72-CB673560D428@microsoft.com...
> How do you reset or reseed the IDENTITY column?

Relevant Pages

  • Re: AFTER INSERT?
    ... If you have an identity column you can really reset the value from within a ... is there a After Insert trigger functionality in SQL Server 2000? ... > and reset it if it has passed a certain limit. ... > It appears that I cannot do this WHILE I am inserting, ...
    (microsoft.public.sqlserver.programming)
  • Re: What the hells wrong with Ebay
    ... I hear that if you just reverse the polarity of the endochronic balancer, it's as good as reset. ...
    (rec.games.video.arcade.collecting)
  • Re: Reset IDENTITY
    ... > Can an IDENTITY column be reset to Seed 1? ... SQL reuse the values. ...
    (microsoft.public.sqlserver.programming)
  • Re: Identity Column Question
    ... Thanks for the feedback and for performing the test using an RPGIV ... If the table of interest in library B also has the column specified as an identity column, I'm not clear as to how you can "reset" the values. ... Clear this file using CLRPFM and rebuild the data in the table ...
    (comp.sys.ibm.as400.misc)
  • Re: Reset Identity Column
    ... Either truncate the table (it will automatically be reset) ... Wayne Snyder, MCDBA, SQL Server MVP ... I have an identity column that ... However it keeps counting from the last ...
    (microsoft.public.sqlserver.server)
Loading