Autogeneration of Serial No. in SQL

[pna3]

I have a column named "Serial Number". I want the Serial Nos. to be auto generated. how do i do this?

 

[jby1]

Set it as an Identity field in Enterprise Manager

 

[pna3]

However, this SerialNo. needs to be displayed on a Visual Basic Screen. As and when every record gets saved the serialNo. should keep incrementing

 

[joebickley]

thats what an indentity field does.

 

[pna3]

I want the SerialNo. to be like for e.g "CC1" then "CC2"

if i use identity it would only generate nos. like "1", "2", etc.

how do i get SerialNos. like
CC1
CC2
CC3
CC4
CC5

 

[fixthebug2003]

You cannot..! You have to generate the field values urself !!

 

[joebickley]

well you could get it to use a default to make the code for you on insert or if the prefix of your serial number doesnt change then u could just put an input mask on it in you VB app.

 

[SQLBill]

You could create a trigger that upon an insert finds the MAX(SerialNumber) and adds 1 to it.

-SQLBill