假设自增量最大为65535,现在已经到头了,前面50000条记录先前已经删除,能否利用起这些空着的id号?
---------------------------------------------------------------
dbcc checkident(表名,reseed,0);
---------------------------------------------------------------
下午才学的:dbcc checkident(yourtable,reseed,0)
编号从新开始
---------------------------------------------------------------
dbcc checkident(表名,reseed,0);
---------------------------------------------------------------
下午才学的:dbcc checkident(yourtable,reseed,0)
编号从新开始