Chandrasekaran C

Chandrasekaran C

  • 1.7k
  • 132
  • 938

How to create auto generate clientID as string + number?

Aug 23 2019 4:28 AM
Hi,
I don't know mssql to create client ID like CLT001, CLT002.... like this as auto generate when insert query performing, In addition can I mark as private key.
 
 
 
I don't want the auto generate using identity  value from numeric ID, I need combination for clientID auto generation.
 
Additional information. 
I use Asp.net and Javascript, Ajax. 

Answers (4)