update employee
set emp_id=t1.rowId
from
(
--select * from
--(
select Emp_UserName,ROW_NUMBER() over(Order by emp_username) as rowId
from employee
) as t1
where t1.Emp_UserName=employee.Emp_UserName
--) as t
