Select 'EmpId : '+ cast(EmpId AS varchar) as EmpId,'Name :'+ EmpName as EmpName FROM Employee
Login to post response