How to assign id by customly?

Question

i have an integer value id, it is okay and it is taking the value by default like 1,2, 3..... now i want to take this value like this 0001, 0002,0003. how can it possible please help me.

 USE [Companybook]
    GO

    /****** Object:  Table [dbo].[Employees]    Script Date: 12/05/2013 14:50:14 ******/
    SET ANSI_NULLS ON
    GO

    SET QUOTED_IDENTIFIER ON
    GO

    CREATE TABLE [dbo].[Employees](
        [EmployeeID] [int] IDENTITY(1,1) NOT NULL,
        [LastName] [nchar](10) NULL,
        [FirstName] [nchar](10) NULL,
        [Country] [nchar](10) NULL,
     CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED 
    (
        [EmployeeID] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
    ) ON [PRIMARY]

    GO

int value can't be `0001`, because `0001` is 1. You can make it `1001` for e.g. — Kamil Budziewski, Dec 05 '13 at 08:52
@Worrior same situation, you can use 12,13,14 not 011,012 etc. — Kamil Budziewski, Dec 05 '13 at 08:56

score 0 · Accepted Answer · answered Dec 05 '13 at 09:31

Hi you cant use 0001 as Identity in Sql, instead of that you can use valid number like 1001,2001,3001......

But you can retrieve the id as you said...

Please refer the link: http://social.msdn.microsoft.com/Forums/en-US/9ae39780-9e95-4e91-bd9f-9f9fc9232084/how-to-make-int-identity-field-showed-like-0001-

http://forums.asp.net/t/1625788.aspx

How to assign id by customly?

1 Answers1