Hi there,
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?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 ...
Showing posts with label age. Show all posts
Showing posts with label age. Show all posts
Friday, February 24, 2012
Alphanumeric Autonumber Primary Key
Subscribe to:
Posts (Atom)