Require to insert alphanumeric value based on identity clmn

Sep 12 2016 6:56 AM

I have a table column

sno identity

emp_id varchar(30)

emp_address (30)

Sno emp_id emp_address emp_address

0001 Rs_0001 kolkatta park

0002 Rs_0002 mumbai gate

0003 Rs_0003 delhi others

Based on identity column sno the empid should be incremented like rs_0001,rs_0002...

Once the form is saved rs_0001 should stored in respective identity coulmn

regards

gowtham,

Answers (5)