There is no such an identity field but you can use computed fields to achieve that output :
CREATE TABLE [dbo].[Customers](
[pk_ID] [int] IDENTITY(1,1) NOT NULL,
[sValue] [char] (10) NULL ,
[sDesc] [char] (10) NULL ,
[iOrd] [numeric](18, 0) NULL ,
[cus_id] AS (substring(CONVERT([varchar],(100000000000.)+[id],0),(2),(11))+' - Do') PERSISTED
) ON [PRIMARY]
Note :
1-
PERSITED
is important if you want to use cus_id in table relations
2- 11 is number of zeros in 100 billion. if you want another number, count its zeros and substitude 11 with it.
3- if you got ARITHABORT error when inserting rows to the table : right click your database in SSMS then select
Properties
then in
options
section set
Arithmetic Abort Enabled
to
True
.
And finally if it solved your problem do no forget to set this as an answer or vote it up :)