-I have Department and Salary column in my table then i created

6.---I have Department and Salary column in my table then i created
-- Differenet AutoGenrate No
--Select left(Department,1)+cast(Salary+EmployeeID AS varchar)as AutoGen1 ,
--left(Department,1)+cast(Salary-EmployeeID+EmployeeID AS varchar) as AutoGen2 FROM Employee