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 vote185 views1 answer
Postgresql certain first 4 characters in string
SQL
0 vote173 views1 answer
Sql contains numeric characters
SQL
0 vote201 views1 answer
Wp_query raw sql
SQL
1 vote203 views1 answer
Vagrant mysql downgrade version
SQL
0 vote176 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote145 views1 answer
Online sql compiler
SQL
0 vote173 views1 answer
Mariadb mysql root access denied
SQL
0 vote173 views1 answer
Mysql find db contarint
SQL
0 vote165 views1 answer
Postgresql conectar
SQL
0 vote196 views1 answer
Which lock mode is not available in sql
SQL