<div>
not sure about starting from 00000001 <br />
but one option could be to set 8 digit<br />
DBCC CHECKIDENT('YourTable', RESEED, 10000000)
</div>


not sure about starting from 00000001
but one option could be to set 8 digit
DBCC CHECKIDENT('YourTable', RESEED, 10000000)

<div>
Hello dark22,<br />
<br />
Why do you need to store the leading zeroes in the database? &nbsp;Why not let it be a simple int identity column,<br />
and then format the result to be 8 digits in your queries/reports?<br />
<br />
Regards,<br />
<br />
Patrick
</div>


Hello dark22,

Why do you need to store the leading zeroes in the database?  Why not let it be a simple int identity column,
and then format the result to be 8 digits in your queries/reports?

Regards,

Patrick

<div>
that maybe the way to go, I don't need to store it in the database, <br />
What happens is a query is run in Access 2000 to import certain records from the first DB into an access table. <br />
<br />
Can you make the access table format it to 8 digits ?
</div>


that maybe the way to go, I don't need to store it in the database,
What happens is a query is run in Access 2000 to import certain records from the first DB into an access table.

Can you make the access table format it to 8 digits ?

<div>
dark22 said:<br />
&gt;&gt;Can you make the access table format it to 8 digits ?<br />
<br />
The same issue applies: you could build the import process to do this, but why bother?
</div>


dark22 said:
>>Can you make the access table format it to 8 digits ?

The same issue applies: you could build the import process to do this, but why bother?

<div>
<div class="content wysiwyg-content">
Hi<br />
I have been told we need an 8 digit auto number given to each new record in our table<br />
starting at 00000001.<br />
<br />
Can this be done ?<br />
<br />
Thanks<br />
<br />
Matt<br />

</div>
</div>


Hi
I have been told we need an 8 digit auto number given to each new record in our table
starting at 00000001.

Can this be done ?

Thanks

Matt


Create a 8 digit auto number

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.