由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Database版 - CO-ASK Re: 请教个sql query问题: sql7
相关主题
Re: 请教个sql query问题: sql7A sql question
SQL7/SQL2000 Replicationhow to make query faster?
关于Acess的简单问题query estimation shows cost 900%?
一个SQL query的问题oracle JDBC thin vs. JDBC OCI
Question 2: distributed database question?再问个excel问题吧
[转载] question about SQL in Access急,SQL2005, 怎么查过去一小时里run过的所有query?
[转载] Can anyone interpret this simple SQL?Late afternoon 腦不好使
请教一个query请教一个mssql的问题
相关话题的讨论汇总
话题: sql话题: sql7话题: access话题: co话题: ask
进入Database版参与讨论
1 (共1页)
j******t
发帖数: 11
1
or it is the way Access primary key goes?
m**********m
发帖数: 92
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 的大作中提到】
: or it is the way Access primary key goes?
j******t
发帖数: 11
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 的大作中提到】
: 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.

1 (共1页)
进入Database版参与讨论
相关主题
请教一个mssql的问题Question 2: distributed database question?
parameterized queries with no inputs[转载] question about SQL in Access
Re: Recordset - I stuck! Help![转载] Can anyone interpret this simple SQL?
A SQL query never stop running is bothering me: help needed (转载)请教一个query
Re: 请教个sql query问题: sql7A sql question
SQL7/SQL2000 Replicationhow to make query faster?
关于Acess的简单问题query estimation shows cost 900%?
一个SQL query的问题oracle JDBC thin vs. JDBC OCI
相关话题的讨论汇总
话题: sql话题: sql7话题: access话题: co话题: ask