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 ...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment