List/Grid Tag Archives: auto increment

You can create an auto-increment or auto-decrement table in SQL Server, which will automatically add value for every new row by incrementing or decrementing the value of last row. These type of Column are known as Identity Column. These kind of columns are generally required where you want to set some kind of ID for any thing like Employee ID in Employee table, Session ID in Session table, Item ID… Read more »