How to combine both row data with column name and get as output

[lohima]

Hi,
i had a table like below which contains some rows and columns.

rowid a b c
1
2
3

now i want the output like

rowid a b c
1 a1 b1 c1
2 a2 b2 c2
3 a3 b3 c3

it's a combination of both row data and column name.

[Rabbit]

I don't see the point of this, but just use the concatenation operator.

SELECT 'a' + rowid, 'b' + rowid, etc...

[lohima]

hi Rabbit,
thank you for ur reply. i tried this already it is showing datatype error.
when i used datatype conversion i am getting the data.

'select 'a'+cast(a as varchar(10))+' '+cast(rowid as varchar(10)','b'+cast(a as varchar(10))+' '+cast(rowid as varchar(10)', etc...'

what i need is i dont want to add column name "['a' +]" here to get output as a1. Is there any other possibility to get column name directly other than giving that name.

thank you

[Rabbit]

You don't really have a choice except to provide the column names. You could query the system tables and build a dynamic query through that, but that's a lot of work.