Data type

Question

User1291898626 posted

My userid column have a primariy key auto increment.

I want that my column value is starting from 0001 instead of 1. How can i do this.

I can change userid column datatypee to int(4) but it insert the value from 1.

Please help.

Answer 1

User1288683547 posted

Its not possible, 0001 or 1 consider numeric 1 only. you can do like create a varchar(4) field, and manual increment as your wishes, or create a trigger.

Answer 2

User1291898626 posted

How can i add manual increment or create trigger to do this.

 

Answer 3

User-638331144 posted

Add a ZEROFILL attribute to your int column.

Answer 4

User1291898626 posted

I can do this but it can show 1 when it view in gridview . please help

Answer 5

User1288683547 posted

you create int auto increment and when you retrive values from that table, use replicate function to fill the zero, or create view

example

CREATE TABLE TESTTABLE
(ID INT PRIMARY KEY IDENTITY(1,1),
 NAME VARCHAR(100))
 
 INSERT INTO TESTTABLE VALUES ('MASTAN')
 INSERT INTO TESTTABLE VALUES ('OLI')
 
 SELECT REPLICATE('0',4-LEN(ID))+CONVERT(VARCHAR,ID) FROM TESTTABLE
 
 CREATE VIEW VIEWTESTTABLE
 AS
 	 SELECT 
		REPLICATE('0',4-LEN(ID))+ CONVERT(VARCHAR,ID) [ID],
		NAME
	 FROM 
		TESTTABLE
 
 SELECT * FROM VIEWTESTTABLE
 SELECT * FROM VIEWTESTTABLE WHERE NAME LIKE 'OLI'