Christian

Site Sections

• Home
• Contact
• Syndication
• Login

Posts

400

Comments

213

Trackbacks

0

Eine Identity-Spalte im SQL-Server zurücksetzen

Für’s Archiv

Mit dem folgenden SQL-Befehl lässt sich der Ientity-Wert einer Tabelle wieder auf "0" zurücksetzen, z.B. nachdem man mit delete oder truncate eine Tabelle geleert hat. Macht natürlich nur Sinn bei Tabellen die keine GUIDs als Identity verwenden.

DBCC CHECKIDENT('Tabellenname', RESEED, 0)

http://msdn.microsoft.com/de-de/library/ms176057.aspx

posted on Friday, February 25, 2011 4:45 PM Print

Archives

• May, 2012 (2)
• April, 2012 (2)
• March, 2012 (2)
• February, 2012 (1)
• January, 2012 (2)
• December, 2011 (1)
• November, 2011 (1)
• October, 2011 (2)
• September, 2011 (2)
• August, 2011 (2)
• July, 2011 (1)
• June, 2011 (2)
• May, 2011 (1)
• April, 2011 (3)
• March, 2011 (3)
• February, 2011 (3)
• January, 2011 (3)
• December, 2010 (4)
• November, 2010 (3)
• October, 2010 (4)
• September, 2010 (2)
• August, 2010 (3)
• July, 2010 (3)
• June, 2010 (2)
• May, 2010 (2)
• April, 2010 (3)
• March, 2010 (3)
• February, 2010 (2)
• January, 2010 (3)
• December, 2009 (3)
• November, 2009 (3)
• October, 2009 (3)
• September, 2009 (2)
• August, 2009 (3)
• July, 2009 (6)
• June, 2009 (5)
• May, 2009 (3)
• April, 2009 (3)
• March, 2009 (5)
• February, 2009 (4)
• January, 2009 (6)
• December, 2008 (15)
• November, 2008 (19)
• October, 2008 (5)
• September, 2008 (8)
• August, 2008 (8)
• July, 2008 (2)
• June, 2008 (2)
• May, 2008 (3)
• April, 2008 (4)
• March, 2008 (6)
• February, 2008 (3)
• January, 2008 (2)
• December, 2007 (1)
• November, 2007 (4)
• October, 2007 (6)
• September, 2007 (7)
• August, 2007 (5)
• July, 2007 (2)
• June, 2007 (9)
• May, 2007 (7)
• April, 2007 (3)
• March, 2007 (1)
• February, 2007 (4)
• January, 2007 (4)
• December, 2006 (5)
• November, 2006 (7)
• October, 2006 (4)
• September, 2006 (2)
• August, 2006 (4)
• July, 2006 (17)
• June, 2006 (21)
• May, 2006 (8)
• April, 2006 (16)
• March, 2006 (22)
• February, 2006 (15)
• January, 2006 (17)
• December, 2005 (10)
• November, 2005 (6)
• October, 2005 (2)
• September, 2005 (1)

Post Categories

• _Allgemein
• off topic
• Tools
• ADO.NET
• - Gridview
• - Allgemein
• - DataAdapter
• - DataReader
• - DataSet
• - DataTable
• ASP
• ASP.Net
• - AJAX
• - Controls
• - CSharp
• - DataGrid
• - DataList
• - MasterPage
• - Menu-Objekt
• - Paging
• - Repeater
• - RSS
• - Tipps
• - VB.NET
• - Web Forms
• Aspose
• - Cells
• CSharp
• Datenbank
• - Access
• - MS-SQL-Server
• - SQL
• - stored procedure
• Framework
• - Architektur
• - Tipps
• QualiSite
• - Allgemein
• - Layout
• - Navigation
• VM
• - Virtual PC
• - VMware
• Webdesign
• - AJAX
• - CSS
• - Javascript
• - Tools
• Impressum
• SharePoint (MOSS)
• - Allgemein
• - Coding tricks
• - Javascript
• - Excel Services
• - code snippets
• - Design
• Visual Studio
• - Add-In

test