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: 
Try this:

Press **Ctrl+T** to get this.

[![enter image description here](https://i.stack.imgur.com/LDoeA.png)](https://i.stack.imgur.com/LDoeA.png)
This will work for you:

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

```