Get the data from the table in the form of fieldname and fieldvalue in SQL Server Is it possible to get the data and column name as a key-value pattern like the table tblemplyee shown below?
UNPIVOT can help you with this.

Try something like 

SELECT employeenumber, fieldname,  fieldvalue
FROM tblmployee e
UNPIVOT(
    FieldValue
    FOR FieldName IN (Gender, JoinDate, MobileNo)
) U


Hope that helps