How to Auto-increment non-integer primary key in sql-server?

Asked Apr 27 '18 at 07:16

Active Apr 27 '18 at 07:16

Viewed 109 times

I am doing a project on asp.net. I have created a table where I want to auto increment the primary key. But the problem is the primary key is not an integer.

For example: In a table reqId is primary key. reqId of a row is suppose SB3001. If another row is inserted its reqID will be SB3002. How to auto-increment this?

asked Apr 27 '18 at 07:16

SB56

have a look at this question https://stackoverflow.com/a/4699628/3953479 – Rajeev Ranjan Apr 27 '18 at 07:20
Use `INT IDENTITY(1,1)` for your PK and add the `SB` to it in the application. – MJH Apr 27 '18 at 07:42
@SB56 I have added my answer in duplicate question as per your requirement. Please check. – DatabaseCoder Apr 27 '18 at 08:16

How to Auto-increment non-integer primary key in sql-server?

0 Answers0