Auto Generate Number Function - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

Auto Generate Number Function

Author

Topic

chennaraaj
Starting Member

17 Posts

Posted - 2011-11-25 : 01:58:08

Hi All

I need one urgent requirment with
Auto generate format like

001
.
.
999 then
A01
..
..
A99
AA1
..
..
AA9
AB1
..
..
AZ9
B01
..
B99
BA1
..
..
like
upto

ZZ9

rk

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2011-11-25 : 02:22:07

refer to Custom Auto-Generated Sequences with SQL Server

KH
[spoiler]Time is always against us[/spoiler]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources