m*m
2 楼
If you are using autonumber in Access or identity in MS SQL Server, then it
works this way. Nothing was wrong. The number is not reset when you delete
records. To reset the autonumber to a certain value, you need to use
DBCC CHECKIDENT to reseed the column at certain value
in sql server 7. Please google its usage and examples.
【在 j******t 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: or it is the way Access primary key goes?
works this way. Nothing was wrong. The number is not reset when you delete
records. To reset the autonumber to a certain value, you need to use
DBCC CHECKIDENT to reseed the column at certain value
in sql server 7. Please google its usage and examples.
【在 j******t 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: or it is the way Access primary key goes?
j*t
3 楼
thanks again! //BOW
just found out that one "stupid" way to solve the problem is to delete the key
and insert it to the table again. then everything works out well.:)
【在 m**********m 的大作中提到】![](/moin_static193/solenoid/img/up.png)
: If you are using autonumber in Access or identity in MS SQL Server, then it
: works this way. Nothing was wrong. The number is not reset when you delete
: records. To reset the autonumber to a certain value, you need to use
: DBCC CHECKIDENT to reseed the column at certain value
: in sql server 7. Please google its usage and examples.
just found out that one "stupid" way to solve the problem is to delete the key
and insert it to the table again. then everything works out well.:)
【在 m**********m 的大作中提到】
![](/moin_static193/solenoid/img/up.png)
: If you are using autonumber in Access or identity in MS SQL Server, then it
: works this way. Nothing was wrong. The number is not reset when you delete
: records. To reset the autonumber to a certain value, you need to use
: DBCC CHECKIDENT to reseed the column at certain value
: in sql server 7. Please google its usage and examples.
相关阅读
请教一个queryQ on adding new column关于多维结构性数据的分类技术问题Reverse an unreversable batch in Oracle?问一个excel的弱问题大侠们,问一个查询怎么写,急!有没有人出来反驳我???借人气问:连MySQL的问题?这里有没有人上过Help! Chart in Access report关于存储计算的问题,请解答Organic chemistry Web菜鸟问个问题Re: 请问怎么在QUERY出来的结果里第一列加上自己的INCREMENTAL NUMB哪里有免费的mySQL database hosting?20050406sqldts转换识别不了怎么办?求助一个随机过程或者概率统计题,谢谢啦help needed about sql statementdatabase exceptionmysql or sqlserver?