How to generate ids in sql

CREATE TABLE dbo.tblUsers
  (ID INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED,
   UserID AS 'UID' + RIGHT('00000000' + CAST(ID AS VARCHAR(8)), 8) PERSISTED,
   .... your other columns here....
  )

Source: stackoverflow.com

Similar codes

0 vote239 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote228 views1 answer
Postgres 11 add primary key
SQL
0 vote257 views1 answer
DELETE DUPLICATE VALUES FROM A TABLE IN SQL SERVER
SQL
13 votes249 views3 answers
Insert mysql ifile nto database
SQL
1 vote246 views1 answer
Oracle difference between two dates in years
SQL
-1 vote214 views1 answer
How to format tables in sqlplus
SQL
0 vote224 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote231 views1 answer
Como hacer un select entre fechas mysql
SQL
0 vote234 views1 answer
Heidisql check how much space a row
SQL
0 vote236 views1 answer
Postgresql not in alternative
SQL