New answers tagged identity
1
vote
Auto-increment [id] field in a table in an SQL-Server database
Typically the best way to get this done if you have to preserve the values in the id column and not manually insert the id is -
CREATE TABLE dbo.Settings_x
(
GroupId INT --or ...
Top 50 recent answers are included
Related Tags
identity × 192sql-server × 133
postgresql × 20
sql-server-2012 × 20
sql-server-2008-r2 × 19
primary-key × 15
insert × 14
database-design × 13
sql-server-2008 × 13
auto-increment × 13
t-sql × 12
sequence × 11
replication × 10
sql-server-2014 × 9
postgresql-10 × 7
oracle × 5
sql-server-2016 × 5
alter-table × 5
mysql × 4
sql-server-2005 × 4
ssms × 4
sql-server-2017 × 4
foreign-key × 4
clustered-index × 4
ddl × 4