Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 auto field

Author  Topic 

amy
Starting Member

30 Posts

Posted - 2002-06-11 : 09:54:32
How can I have the auto # start with 01 instead of 1?

Thanks

Nazim
A custom title

1408 Posts

Posted - 2002-06-11 : 10:23:12
therez no way you can do that on a numeric field in Sql server. better have a varchar field and write a trigger to get the work done.



-------------------------
What lies behind you and what lies ahead of you are small matters compared to what lies within you.-Ralph Waldo Emerson
Go to Top of Page
   

- Advertisement -