Top "Identity-column" questions

An Identity column is a column in a database table that is made up of values managed by the server and cannot be modified, to be used as a primary key for the table.

RESEED identity columns on the database

Can I use the DBCC CHECKIDENT(<table_name>, RESEED, value) command to reset an identity column current value …

sql-server sql-server-2008 identity-column
SQL Reset Identity ID in already populated table

hey all. I have a table in my DB that has about a thousand records in it. I would like …

sql identity-column
Auto-increment on Azure Table Storage

I am currently developing an application for Azure Table Storage. In that application I have table which will have relatively …

concurrency primary-key azure-storage auto-increment identity-column
Column to be modified is not an identity column

I have created a table with column S_ROLL NUMBER(3) NOT NULL Now I want to make this colum to …

oracle identity-column
Remove [NOT FOR REPLICATION] from all Identity columns of Database tables

I have a Database which is containing lot of tables with Identity columns set to [NOT FOR REPLICATION]. in SQL …

sql sql-server sql-server-2008-r2 replication identity-column
How do I easily find IDENTITY columns in danger of overflowing?

My database is getting old, and one of my biggest INT IDENTITY columns has a value around 1.3 billion. This will …

sql-server overflow maintenance identity-column information-schema
Excel - Tell me the column header that had the highest number for each row

| Name | Blues | Greens | Yellows | Reds | Winner | | Smith | 35 | 42 | 52 | 17 | | I want to know the column header that has the largest number for …

excel identity-column
T-SQL: CTE with identity columns

I'm building a tree (bill of materials style), and transforming some data. Consider the following table: BillOfMaterials BomId ParentId Now …

sql-server-2008 common-table-expression identity-column
SQL: Will setting IDENTITY_INSERT ON disable updating the table's identity table?

I'm currently working on a data migration project and for performance related issues, I want to predefine a set of …

sql sql-server performance identity-column
SQL Server continue identity count after truncating table

I seem to remember in MySQL when truncating a table the auto incremented index field would continue where it left …

sql-server identity-column