Introduction:
In this article I will explain how to set custom auto increment or auto generated column during insertion of record in SQL server.
Description:
In this article I will explain how to set custom auto increment or auto generated column during insertion of record in SQL server.
Description:
In previous article I explained how to set auto identity column in SQL Server to generate a unique number for newly insert records like 1, 2, 3, 4, 5…etc based on records insertion. This identity column will work only for integer values. Suppose if I want to set id value starts from 08U13000 and increase that value based on new records inserted in table like 08U13000, 08U13001, 08U13002, etc… In this case auto identity property won’t work for us because it supports only for integer values.