指点迷津:自增量identity(1,1)快到头了,如果不改变字段类型的话,怎么解决?

假设自增量最大为65535,现在已经到头了,前面50000条记录先前已经删除,能否利用起这些空着的id号?
---------------------------------------------------------------

dbcc checkident(表名,reseed,0);

---------------------------------------------------------------

下午才学的:dbcc checkident(yourtable,reseed,0)
编号从新开始

Published At
Categories with 数据库类
Tagged with
comments powered by Disqus