Question: How to change My result set in `sql server 2012`

My Result set is

```
Name   Age   Gender
 X      21     M
 Y      21     F

```

I need this type of result

```
Name|Age|Gender
X|21|M
Y|21|f

```

Including column names

Answer: 
I think this will work

```
 select Convert(nvarchar(50),name)+'|'+Convert(nvarchar(50),age)+'|'+Convert(nvarchar(50),gender) as column from table_name

```
This will work for you:

```
select(convert(nvarchar(50),Name)+'|'+convert(nvarchar(50),Age)+'|'+convert(nvarchar(50),Gender)) 
[Name|Age|Gender]  from [Table_Name]

```