Home > Database > Mysql Tutorial > Cannotupdateidentitycolumn'XXX'

Cannotupdateidentitycolumn'XXX'

WBOY
Release: 2016-06-07 16:01:25
Original
2040 people have browsed it

Sqlserver -- 如何修改设置主键的id可以手动更新? #1 打开表的设计界面 #2 将主键id的is Identity的属性改成No 这样就可以通过Update语句来更新表的主键id了。 vcD4KPHA+PHN0cm9uZz7I57rO1tjQwsno1sPW97z8aWS1xNfU1PazpL+qyrwmIzIwNTQwO8TYo788L3N0cm9uZz48

Sqlserver -- 如何修改设置主键的id可以手动更新?

#1 打开表的设计界面

\

#2 将主键id的is Identity的属性改成No

\

这样就可以通过Update语句来更新表的主键id了。喎?http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHA+PHN0cm9uZz7I57rO1tjQwsno1sPW97z8aWS1xNfU1PazpL+qyrwmIzIwNTQwO8TYo788L3N0cm9uZz48L3A+CjxwPiMxIMP8we6jukRCQ0MgQ0hFQ0tJREVOVCAodGFibGVOYW1lLCByZXNlZWQsIDEwMDAwMDApPC9wPgo8cD4jMiBEQkNDOiA8L3A+CjxwPkRCQ0MgaGVscCg="?') 查看所有的dbcc命令

DBCC HELP('checkdb') 查看单个命令的详细

Related labels:
amp
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template