如何以编程方式更改标识列值? [英] How to change identity column values programmatically?

查看:30
本文介绍了如何以编程方式更改标识列值?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有一个 MS SQL 2005 数据库,其中有一个表 TestID 列.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

这篇关于如何以编程方式更改标识列值?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆