I am aware that using identity column we can auto-increment the keys from 0, one-by-one. What I want to do is:
Generate codes in SQL server 2014 which will be of 9 digits (operational codes).
First 2 digits are going be pre-defined and remaining 7 will increment by 1 for every new insertion of record. For example:
51 (predefined ) and remaining 7 are 0000001 and so insertions will happen as:
510000001 510000002 510000003 510000004 510000005 510000006
and so on.