evolet10000
Active member
- Joined
- Nov 22, 2012
- Messages
- 40
- Programming Experience
- Beginner
hi there, i have a SQL SERVER 2008 table with 3 columns(P_ID(Primary key), PRODUCT_NAME, DESCRIPTION),
now, how can i generate a custom and unique(ofcourse) value for my primary key,
for example: sc00001 in the 1st row, and when i enter another data it will generate sc00002 something like that,
just wondering if someone here give teach me how? instead of using auto-increment function..
thanks in advance
now, how can i generate a custom and unique(ofcourse) value for my primary key,
for example: sc00001 in the 1st row, and when i enter another data it will generate sc00002 something like that,
just wondering if someone here give teach me how? instead of using auto-increment function..
thanks in advance