SQLTeam.com | Weblogs | Forums

Auto increment nvarcahr id

sql2008r2

#1

Dear sir Goodmorning. I have two table, one is TBL_EMP and second is TBL_DEPARTMENT TBL_EMP EMPID, DEPTID, EMPNAME, DOJ, DOB ..... TBL_DEPARTMENT DEPTID, DEPTNAME,
FOR EXAMPLE DEPTNAME are executive, Manager, CEO, I have require empID ex1001, ma1002, CE0003 and so on.............