Loading

how can I fetch column name and its data using query?

Fareeda Hussain

9y753

Hi

Can I retrieve the column name and its particular data as two column values .Its possible to fetch column name from INFORMATION_SCHEMA.COLUMNS.Can we get

the data also with the same query like

set @tsql = 'select '+@col +' = Column_name,(select @col from @tablename)

from INFORMATION_SCHEMA.COLUMNS

where Table_name like '''+@tablename+'''

exec(@tsql);

.Or can we put for loop inside the stored procedure

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke9y ago
It would be really helpful if you could mention what exactly you are trying to achieve. Because there are more than one solutions to a problem.

In addition, where will you be trying to fetch column names? Is it in a code written in C#?

Please provide answers and we would be in a better position to help you!
0