Jampandu (11/28/2014)
we are using sql 2014. we can implement the solution using sequences
How? Sequences do not allow apha-numeric data. They can only be of these types:
tinyint - Range 0 to 255
smallint - Range -32,768 to 32,767
int - Range -2,147,483,648 to 2,147,483,647
bigint - Range -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807
decimal and numeric with a scale of 0
Gerald Britton, Pluralsight courses