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)

Clause ORDER BY doesn’t work in VIEWS

Stored Procedure