Example of automatic value-added setting ID in SQLServer2000/2005

In SQL2000, we set automatic value-added. We select yes in the ID, and then set the seed and ID increment of the following id. The seed is the starting number of the ID, the increment is the number added each time. As shown in the following figure:

SQL2000 identification method

But there are not so many in SQL2005. The setting method is different. As shown in the following figure, the column attribute does not have any options for setting Identifiers. Only the table attribute on the right has an identifiers. If you set the ID to auto-increment, write the ID in the ID column or select from the drop-down list. But in 2005, there is no seed and ID increment for the logo. Here, it is automatically set to 1. You only need to select the ID column.

Add ID auto-increment method in sql2005

But there are not so many in SQL2005. The setting method is different. As shown in the following figure, the column attribute does not have any options for setting Identifiers. Only the table attribute on the right has an identifiers. If you set the ID to auto-increment, write the ID in the ID column or select from the drop-down list. But in 2005, there is no seed and ID increment for the logo. Here, it is automatically set to 1. You only need to select the ID column.