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 vote262 views1 answer
Oracle last connection
SQL
0 vote226 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote278 views1 answer
Declare date variable sql
SQL
0 vote272 views1 answer
Mysql get last 2 month data
SQL
3 votes264 views2 answers
Mysql time
SQL
3 votes268 views1 answer
V$session not found in oracle
SQL
0 vote300 views1 answer
List in one column mysql
SQL
5 votes269 views1 answer
Oracle sysdate
SQL
2 votes292 views1 answer
Oracle sql merge
SQL
0 vote332 views2 answers
Sql query print strings and int
SQL