var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Alphanumeric Autonumber Primary Key
The age old question of creating a unique alphanumeric value automatically like ABC0001, ABC0002
Is it possible to do this automatically? That is, without having to update it which will slow the db down horribly?
If at first you don't succeed, call it version 1.0
the only sane way of doing it is to have an ordinary integer identity column, then produce the alphanumeric value in a view
create view myview as
select 'ABC'+right(cast(pkey as varchar(9)),4) as myalnumkey ...
vb.net code to increment alphanumeric primary key
Please help to get code for above
Originally Posted by nikitacruise
this thread is over 5 years old
if you have a problem, please start a new thread
I may be being thicker than usual, but why would you want an alphanumeric auto increment key?