Sometimes, as when testing a table in a Microsoft SQL Server database, you need to reset an identity column to its initial seed value, typically one. During testing, you populate the table with data, ...
Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Cory Benfield discusses the evolution of ...
I suspect that a Jet call to modify a field to identity might exist, but I have no idea what it is if it does.<BR><BR>If you're going to eventually be using SQL server, I highly suggest downloading an ...
Microsoft SQL Server MVP Denny Cherry breaks down multiple ways on how to troubleshoot a type -2 blocking session ID error. When we look at sessions being blocked in ...
[projectNumber] [int] IDENTITY (2000, 1) NOT NULL , [projectYear] [char] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [description] [varchar] (255) COLLATE SQL ...
UPDATE: The story that originally got my attention has been updated in all of the places I could still find it yesterday, so I’m pulling my references to the story and just focusing on the positive ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results