Generate custom unique key in SQL Server

Hi nauna,

This is custom Value you cannot increment it like normal integer value we increment in SQL.

As its Alphanumeric value with combination of first and last character as alphabets an rest is numeric you need to always get last value of column from table before each insert and you need to use substring to split the combination value and then you have to check each spilted value to increment it for Numeric part as well as For last letter and if last later reached to z character then you need to increment first later with newer later by ASCII value and you need to use it in Insert Statement.