SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE tab(
   autoincrement_id INT IDENTITY(1,1),
   crypto_id AS (HASHBYTES('SHA2_256',CAST(autoincrement_id AS NVARCHAR(MAX)))) PERSISTED
);
INSERT INTO tab DEFAULT VALUES;
INSERT INTO tab DEFAULT VALUES;
INSERT INTO tab DEFAULT VALUES;
INSERT INTO tab DEFAULT VALUES;
INSERT INTO tab DEFAULT VALUES;
INSERT INTO tab DEFAULT VALUES;
6 rows affected

SELECT * FROM tab;


autoincrement_id
crypto_id


1
0xE79E418E48623569D75E2A7B09AE88ED9B77B126A445B9FF9DC6989A08EFA079

2
0x913DA1F8DF6F8FD47593840D533BA0458CC9873996BF310460ABB495B34C232A

3
0xAC11339FFA8F270C4F781E0A3922BB1C80D9DEE6E4B6911CA34538ED9AE03CAA

4
0x3089C464221340FED4229D6BA913A04224C91B44158C22163E8849EB7DCC4878

5
0x166F829E016F2315A8099E3A8D2DBEC6D91572379FF02C760BA4E0335789D47F

6
0xAA4FB8A61CAB7DB73F42671F2BB987A7291A436929B3D5F17FFE05F96BE13371

autoincrement_id	crypto_id
1	0xE79E418E48623569D75E2A7B09AE88ED9B77B126A445B9FF9DC6989A08EFA079
2	0x913DA1F8DF6F8FD47593840D533BA0458CC9873996BF310460ABB495B34C232A
3	0xAC11339FFA8F270C4F781E0A3922BB1C80D9DEE6E4B6911CA34538ED9AE03CAA
4	0x3089C464221340FED4229D6BA913A04224C91B44158C22163E8849EB7DCC4878
5	0x166F829E016F2315A8099E3A8D2DBEC6D91572379FF02C760BA4E0335789D47F
6	0xAA4FB8A61CAB7DB73F42671F2BB987A7291A436929B3D5F17FFE05F96BE13371