Dear All,
I have to create the auto Generation Number in sql like Identity but
The Problem is
The Data like the below format
00001
00002
.
.
.
.
00010
00011
00012 Etc
Is it possible? I know the INT,NUMERIC, will void the prefix zeros
But is it possible to bring this format in result set?