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

2 votes117 views1 answer
Mysql Incorrect column specifier for column
SQL
0 vote116 views1 answer
How to reset the database value in SQL server
SQL
1 vote109 views1 answer
Psql connections
SQL
1 vote116 views1 answer
Mysql dump specific tables
SQL
0 vote110 views1 answer
How to create an SQL save method in ruby
SQL
3 votes120 views2 answers
Mysql config user password
SQL
1 vote112 views1 answer
Duplicating a MySQL table with all the data Command
SQL
0 vote116 views1 answer
T-SQL Create Trigger
SQL
0 vote121 views1 answer
Update having mysql
SQL
0 vote120 views1 answer
Postgres statistics
SQL