Reset Identity Column Value in SQL Server Reset Identity stolpec Vrednost v SQL Server

If you are using an identity column on your SQL Server tables, you can set the next insert value to whatever value you want. Če uporabljate identiteta stolpec na vaši tabelah SQL Server, lahko nastavite naslednjo vrednost vstavite v karkoli vrednost, ki jo želite. An example is if you wanted to start numbering your ID column at 1000 instead of 1. Primer za to je, če si hotel začeti številčenje vaš ID stolpec na 1000 namesto 1.

It would be wise to first check what the current identify value is. To bi bilo pametno, da najprej preverite, kaj trenutno opredeliti vrednost. We can use this command to do so: Mi lahko uporabite ta ukaz, da to stori:

DBCC CHECKIDENT ('tablename', NORESEED) DBCC CHECKIDENT ( 'TABLENAME', NORESEED)

For instance, if I wanted to check the next ID value of my orders table, I could use this command: Na primer, če sem želela preveriti naslednje vrednosti ID mojih naročil tabele, sem lahko uporabite ta ukaz:

DBCC CHECKIDENT (orders, NORESEED) DBCC CHECKIDENT (naročil, NORESEED)

To set the value of the next ID to be 1000, I can use this command: Če želite nastaviti vrednosti naslednjih ID za 1000, lahko uporabite ta ukaz:

DBCC CHECKIDENT (orders, RESEED, 999) DBCC CHECKIDENT (naročil, RESEED, 999)

Note that the next value will be whatever you reseed with + 1, so in this case I set it to 999 so that the next value will be 1000. Upoštevajte, da bo naslednja vrednost karkoli reseed z + 1, tako da v tem primeru sem jo nastavite na 999, tako da bo naslednja vrednost 1000.

Another thing to note is that you may need to enclose the table name in single quotes or square brackets if you are referencing by a full path, or if your table name has spaces in it. Druga stvar je tudi omeniti, da bo morda treba priložiti ime tabele v enojnih narekovajih, ali oglatih oklepajih, če ste navajanje s celotno pot, ali če je vaše ime tabele ima prostore v njem. (which it really shouldn't) (ki ga res ne bi smelo)

DBCC CHECKIDENT ( 'databasename.dbo.orders',RESEED, 999) DBCC CHECKIDENT ( 'databasename.dbo.orders', RESEED, 999)

| | More Več

This article was originally written on 03/7/07 Tagged with: Ta članek je bil prvotno napisan na 03/7/07 Tagged with: Database Database , , SQL Server SQL Server

Daily Email Updates Dnevni Email Updates

You can get our how-to articles in your inbox each day for free. Lahko dobite našo kako do člankov v vašo mapo »Prejeto vsak dan brezplačno. Just enter your name and email below: Preprosto vpišite vaše ime in e-pošto spodaj:

Name: Ime:
Email: E-pošta:

Similar Articles Podobni členi	Tinyhacker - Tiny Geek Hacks Tinyhacker - Tiny Geek Hacks
Command Line Hack for: "Terminal Server Has Exceeded the Maximum Number of Allowed Connections" Command Line Hack za: "Terminal Server je preseglo največje dovoljeno število Connections" Keyboard Ninja: Insert Tables in Word 2007 Keyboard Ninja: Vstavljanje tabele v Wordu 2007 Easier Table Column Selection in Microsoft Word Lažje tabeli stolpec Selection v Microsoft Word How to Send and Receive Hotmail from Thunderbird Kako pošiljati ter sprejemati Hotmail iz Thunderbird See Task Type at a Glance by Adding the Icon Column to the Outlook 2007 To-Do Bar Glej Task Type na dlani, ki jih dodate Icon Column za Outlook 2007 To-Do Bar	99 freeware programs to trick out your PC 99 avtocesta programe za trik iz računalnika Add CPU and Memory Meters to Your Windows 7 Taskbar Dodaj CPU and Memory Merilniki to Your Windows 7 penzum Nice Brushed Firefox Theme With Extras Nice Brushed Firefox Theme With Extras Make your website mobile friendly using Mobify Naredite svojo mobilno prijazne spletne strani z uporabo Mobify Change Your Windows 7 Logon Screen Easily Change Your Windows 7 Logon Screen lahek Newspaper Front Pages in Flash Newspaper Front Strani v Flash
Latest Software Reviews Zadnji Software Reviews	Super User Daily Super User Daily
Cakewalk Guitar Tracks Pro USB Prosto kot pasulj Guitar Tracks Pro USB BitDefender Total Security 2010 BitDefender Total Security 2010 Returnil Virtual System 2010 Home Returnil stvaren sistem 2010 Home Norton Internet Security 2010 Norton Internet Security 2010	Upgrade pirated Vista to Windows 7? Nadgradnja na operacijski sistem Windows Vista pirat 7? play with windows 7 on vmware igra s okno 7 na VMware Can't connect iPhone to my wireless router @home Ne morem povezati iPhone z mojim brezžičnim usmerjevalnikom @ home What's the difference between 32 & 64 bit Windows for hardware Kakšna je razlika med 32 in 64 bitni operacijski sistem Windows za strojno opremo
Geek Arcade Geek Arcade	Popular Forum Threads Forum Popular Threads
Demolition City Rušenje City Heavy Weapons Heavy Weapons Epic War 3 Epic War 3 Gravitee 2 Gravitee 2	Trojan Found ! Trojan Found! Latest security suites comparison Zadnje varnost spremstvo primerjavo How to show Column Bar in Windows 7 Kako prikazati Stolpec Bar v operacijskem sistemu Windows 7 I cannot find SATA harddrive disable option Ne najdem SATA harddrive onemogoči možnost

Comments (15) Komentarji (15)

1. March 23, 2007 10:04 pm 23. marec 2007 10:04
   Rukowen Rukowen

   wonderful.. čudovito ..
   That's all I need, Thanks in advanced!… To je vse, kar potrebujem, hvala napredno! ...
   Have a nice weekend.. Lep vikend ..

2. April 23, 2007 11:48 pm 23. april 2007 11:48
   Himani Himani

   Hey,, Hej,,
   thus is what inwas looking for.. Tako je tisto, kar inwas išče ..
   gee thankss Gee thankss

3. May 7, 2007 10:02 pm 7. maj 2007 10:02
   kevin kevin

   thanks! hvala!

4. June 7, 2007 10:12 am 7. junij 2007 10:12
   Ste Ste

   Mitico! Mitico!

5. July 28, 2007 4:21 pm 28. julij 2007 4:21
   Dominic Herard Dominic Herard

   Thanks a whole lot! Hvala celotno serijo!

6. February 8, 2008 10:10 am 8. februar 2008 10:10
   Nick Nick

   great concise page. zelo kratek stran. thanks. hvala. way easier than ms help files. Tako lažje kot ms datoteke s pomočjo.

7. March 12, 2008 4:13 am 12. marec 2008 4:13
   lakshmi Lakshmi

   This is great. To je super. But how to make the following code work: Ampak, kako narediti naslednji delovni kodo:
   declare @seqno int razglasi @ seqno int
   set @seqno = DBCC CHECKIDENT (orders, NORESEED) iz @ seqno = DBCC CHECKIDENT (naročil, NORESEED)
   DBCC CHECKIDENT ( 'databasename.dbo.orders',RESEED, @seqno) DBCC CHECKIDENT ( 'databasename.dbo.orders', RESEED, @ seqno)

8. April 15, 2008 5:43 pm 15. april 2008 5:43
   tdow tdow

   I created a script that will do what you want, lakshmi. Ustvaril sem scenarij, da bo to, kar hočeš, Lakshmi. Just replace MyId and mytbl below: Preprosto zamenjajte MyId in mytbl spodaj:

   DECLARE @MaxId INT IZJAVLJAM @ MaxId INT

   SELECT @MaxId = MAX( MyId ) SELECT @ MaxId = MAX (MyId)
   FROM mytbl (NOLOCK) IZ mytbl (NOLOCK)

   PRINT 'Resetting Identity value to : ' + CONVERT( VARCHAR, @MaxId ) PRINT "Ponastavitev Identity vrednost:" + CONVERT (varchar, @ MaxId)
   PRINT ” PRINT "

   DBCC CHECKIDENT ('mytbl', RESEED, @MaxId) DBCC CHECKIDENT ( 'mytbl', RESEED, @ MaxId)

   PRINT ” PRINT "

   – Verify - Preverite
   DBCC CHECKIDENT ('mytbl', NORESEED) DBCC CHECKIDENT ( 'mytbl', NORESEED)

9. October 8, 2008 11:39 am 8. oktober 2008 11:39
   Jeff Jeff

   Thanks Geek – worked like a charm Hvala Geek - obdelan brezhibno

10. April 6, 2009 7:14 am 6. april 2009 7:14
    Amit Yenurkar Amit Yenurkar

    Thanks a lot!!!!!!!!! Hvala veliko !!!!!!!!!
    Useful Stuff………… Koristne Stuff ... ... ... ...

11. July 2, 2009 6:55 am 2. julij 2009 6:55
    Nirman Doshi Nirman Doshi

    Thanks a lot Hvala veliko
    i was searching for this sem bil za to iskanje

12. July 22, 2009 7:39 pm 22. julij 2009 7:39
    haridsv haridsv

    Thanks a lot. Hvala veliko. For me, if I use the value of 0 to reseed, sql server 2005 didn't start from 1, but actually from 0. Za mene, če jaz raba vrednost od 0 do reseed, SQL Server 2005, ni začela s 1., ampak dejansko od 0. May be the +1 statement is not correct? Lahko je 1 izjava ni pravilna?

13. August 4, 2009 9:03 am 4. avgust 2009 9:03
    Prodis Prodis

    Thank you for information. Hvala za informacije. It was usefull. Bilo je koristno.

14. September 4, 2009 11:05 pm 4. september 2009 11:05
    Yogesh Yogesh

    Thanks Hvala

15. September 18, 2009 5:21 am 18. september 2009 5:21
    Ric Ric

    Brilliant, thanks Brilliant, hvala