SQL Server : return column names based on a record's value

Your question is same as stackoverflow:

 

http://stackoverflow.com/questions/27285569/sql-server-return-column-names-based-on-a-records-value

 

http://stackoverflow.com/questions/33758294/retrieve-the-value-with-column-name-and-corresponding-values-in-t-sql 

"No" is the answer but please don't take it.

 

Could you please elaborate what exactly you are trying to achieve?

 

And does the solution should be on server side only? (because it is possible to do it once the result set is in C# (Java) because there you get all the metadata.