ms 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:21 UTC
Read the original article
Hit count: 335
sql-server-2005
hi there,
I'm using MS 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