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.
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'
unique
Member
125 Points
100 Posts
Data type
Mar 30, 2012 09:49 AM|LINK
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.
Mastan Oli
Contributor
5100 Points
999 Posts
Re: Data type
Mar 30, 2012 10:05 AM|LINK
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.
playingOOPS | மெய்ப்பொருள் காண்பதறிவு
Mark as Answer If you find helpful
unique
Member
125 Points
100 Posts
Re: Data type
Mar 30, 2012 10:48 AM|LINK
How can i add manual increment or create trigger to do this.
bugwee
Member
354 Points
72 Posts
Re: Data type
Apr 03, 2012 03:25 AM|LINK
Add a ZEROFILL attribute to your int column.
unique
Member
125 Points
100 Posts
Re: Data type
Apr 03, 2012 05:15 AM|LINK
I can do this but it can show 1 when it view in gridview . please help
Mastan Oli
Contributor
5100 Points
999 Posts
Re: Data type
Apr 03, 2012 06:16 AM|LINK
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'playingOOPS | மெய்ப்பொருள் காண்பதறிவு
Mark as Answer If you find helpful