Gowtham

Gowtham

  • 1.5k
  • 516
  • 27.3k

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)
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)