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 vote277 views2 answers
How to start postgresql laravel
SQL
0 vote305 views1 answer
Get the next column of a table in mysql
SQL
0 vote286 views4 answers
Change schema in sql server
SQL
8 votes316 views1 answer
Oracle search stored procedures for text
SQL
0 vote289 views1 answer
Postgres : ERROR: division by zero
SQL
0 vote280 views1 answer
Get server date mysql
SQL
10 votes245 views2 answers
Django mysql
SQL
34 votes297 views6 answers
Install mysql client ubuntu
SQL
4 votes356 views2 answers
Sql display today's date
SQL
3 votes279 views2 answers
Oracle synonym
SQL