使用自动增量设置列的起始值 [英] Set start value for column with autoincrement
问题描述
我有一个表 Orders
包含以下字段:
身份证 |小计 |税|航运 |创建日期
Id
列设置为 autoincrement(1,1)
.
这将用于电子商务店面.有时,当前的电子商务商店迁移到我的平台并且他们已经有订单 - 这可能意味着他们当前的 Order.Id
是,例如,9586
.>
我想让 autoincrement
字段从那个值开始.
我该怎么做?
检索表 Employees
的标识:
DBCC checkident ('Employees')
修复身份种子(如果由于某种原因数据库正在插入重复的身份):
DBCC checkident ('Employees', reseed)
将表 Employees
的身份种子更改为 1000:
DBCC checkident ('Employees', reseed, 1000)
插入的下一行将从 1001 开始.
I have a table Orders
with the following fields:
Id | SubTotal | Tax | Shipping | DateCreated
The Id
column is set to autoincrement(1,1)
.
This is to be used in an E-commerce storefront. Sometimes a current E-commerce store is migrated to my platform and they already have orders - which could mean that their current Order.Id
is, for example, 9586
.
I want to have the autoincrement
field start from that value.
How can I do this?
From Resetting SQL Server Identity Columns:
Retrieving the identity for the table Employees
:
DBCC checkident ('Employees')
Repairing the identity seed (if for some reason the database is inserting duplicate identities):
DBCC checkident ('Employees', reseed)
Changing the identity seed for the table Employees
to 1000:
DBCC checkident ('Employees', reseed, 1000)
The next row inserted will begin at 1001.
这篇关于使用自动增量设置列的起始值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!