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.
| Author |
Topic |
|
burwelj
Starting Member
4 Posts |
 Posted - 2007-07-12 : 16:52:38
|
| Is is possible to have an identity seed with leading zeros? If so, how do you do this? |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2007-07-12 : 16:56:29
|
| what do you mean?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-07-12 : 16:57:25
|
| That is not possible since the data type must be in the numbers family. If you want something like 01, 02, 03, then you need to use varchar and you'll have to code for the increments.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
burwelj
Starting Member
4 Posts |
Posted - 2007-07-12 : 17:02:33
|
| thanks tkizer, thats the info i was looking for. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-07-12 : 18:23:45
|
you still can use numbers if you want and during presentation of the number, append the leading zeroes that you required.
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
identity seed with leading zeros?