SQL Server identity counterpart problem
Posted
by Guru
on Stack Overflow
See other posts from Stack Overflow
or by Guru
Published on 2010-03-21T09:11:08Z
Indexed on
2010/03/21
9:31 UTC
Read the original article
Hit count: 167
Filed under:
sql-server-2005
Hi there,
I'm using SQL Server and I want to use identity constraint in it
I know how to use it in following manner
create table mytable
(
c1 int primary key identity(1,1);
)
the above code works fine but what if i want the identity column to have values as EMP001, EMP002,... instead of 1,2....
Thanks in advance, Guru
© Stack Overflow or respective owner
