I want to ask something about in MSSQL database.
I have a database one and it has E-mail,Mobile Number,AuthCode,UserID.
I want to that ; When i add new user AuthCode Column will be like this : UserID+Mobile Number.
Like this : if new user has 05518602015 mobile number and UserID(Autoincrement)=2 Automatically AuthCode Columun will be create like : 205518602015
How can i do this ? I'm new sql server