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 vote154 views1 answer
Get last updated row sql server
SQL
0 vote112 views1 answer
Postgres create database if not exists
SQL
0 vote170 views1 answer
Query to insert image
SQL
0 vote140 views1 answer
Sql tabelle erstellen
SQL
0 vote134 views1 answer
Postgresql heritage
SQL
0 vote139 views1 answer
Add timestamp column to existing table ms sql server
SQL
6 votes146 views2 answers
Mysql interval 1 day
SQL
0 vote179 views1 answer
Grouping by email domain mysql
SQL
0 vote144 views1 answer
<connectionStrings> <add name="MainDB" connectionString="Data Source=multidc02.its.com.pk,47328;Initial Catalog=ITSGeneralApplications;User ID=ITSGeneralAdmin;Password=TDsHn6TTyJohXCe"/> </connectionStrings>
SQL
0 vote139 views1 answer
How to see password mysql vestacp
SQL