ID生成 [英] ID Generation

问题描述

Hello Everyone 

Hello Everyone 

 我在SQL Server中创建了一个数据库，将ID设置为Auto，但在添加多个记录后通过用户界面插入数据时，ID的增量超过了我在数据库中设计的值，例如，如果它是1000，则增加到2000
我不知道有什么问题请帮助我找到合适的解决方案。

  I have created a database in SQL Server set the ID to Auto but while inserting data through user interface after adding several records the ID increments more than what I designed in the database for example If it is 1000 it is incremented to 2000 I don't know what is wrong please help me in finding a proper solution.

以下是我使用的VB代码 

Following are the VB codes that I used 

Private Sub btnDMInsert_Click（sender As Object，e As EventArgs）处理btnDMInsert.Click

Private Sub btnDMInsert_Click(sender As Object, e As EventArgs) Handles btnDMInsert.Click

 尝试

Nadem

推荐答案

 如果是1000则增加到2000 

 If it is 1000 it is incremented to 2000 

Nadem

然后？

如果它不是2001年，那么你可能已经删除了999个

If it is not 2001 then you have probably removed 999 ones

这篇关于ID生成的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！