This is my view:
FROM e.Employee e
JOIN EmployeeTeam et
ON e.EmpId = et.EmpId
JOIN Team t
ON eg.TeamId = t.TeamId
JOIN TeamArea ta
ON ta.TeamId = t.TeamId
JOIN Department d
ON d.DepartmentId = ta.DepartmentId
Where EmpId is primary key in Employee table and EmpNo is not unique and key field.
I need to add a new column named
Id and I need to this column be unique so I think to add new column as identity.
If that is possible how to do this?