Hi.
I intend to design a form by Asp.net that employees insert their personal information , and then these data to be stored in DB(Sqlserver 2008r2).
in my DB logical design , i had supposed to be:(PersonelCode,Int, pk,unique,not null)
but my problem is : someone told me that PersonelCode datatype shouldn't be Int, because some of them include words, or begin from Zero(example: 0343),
so what shall i do , is it correct to change the datatype to String ? if yes , how can keep it unique and to specify person's identificaion?