如何以编程方式更改标识列值?
我有一个 MS SQL 2005 数据库,其中有一个表 Test
和 ID
列.ID
是一个标识列.
I have a MS SQL 2005 database with a table Test
with column ID
. ID
is an identity column.
我在这个表中有行,所有行都有相应的 ID 自动递增值.
I have rows in this table and all of them have their corresponding ID auto incremented value.
现在我想像这样更改此表中的每个 ID:
Now I would like to change every ID in this table like this:
ID = ID + 1
但是当我这样做时,我得到一个错误:
But when I do this I get an error:
无法更新身份列ID".
Cannot update identity column 'ID'.
我已经试过了:
ALTER TABLE Test NOCHECK CONSTRAINT ALL
set identity_insert ID ON
但这并不能解决问题.
我需要为此列设置身份,但我也需要不时更改值.所以我的问题是如何完成这个任务.
I need to have identity set to this column, but I need to change values as well from time to time. So my question is how to accomplish this task.
推荐答案
您需要
set identity_insert YourTable ON
然后删除您的行并以不同的身份重新插入.
Then delete your row and reinsert it with different identity.
完成插入后不要忘记关闭identity_insert
Once you have done the insert don't forget to turn identity_insert off
set identity_insert YourTable OFF
相关文章