Return ColumnNames from Select query in SQL Server?

Question

First i written select query with join for retrieving required columns. After that using Top 0 i got the required columns. Which will come like this,

i dont want any records. but i need the result of only the column names like this,

enter image description here

sample code:

select Top 0 *tablename*.* from my *tablename*
(some joins and where conditions)

tablename => contains dynamic columns (After doing joins)

are you perhaps looking for a PIVOT? it's hard to say from your question. — Mitch Wheat
– Mitch Wheat, Commented Jun 1, 2014 at 10:20
Far from clear, but what if you got the column names from querying say syscolumns, Wouldn't need the dynamic sql either, just join to systables. — Tony Hopkinson
– Tony Hopkinson, Commented Jun 1, 2014 at 10:41
@TonyHopkinson its not a sys columns columns and table names are dynamic... — Karthik
– Karthik, Commented Jun 1, 2014 at 10:59

Horaciux · Accepted Answer · 2014-06-01 14:09:48Z

1

Inspired on @Tony Hopkinson suggestion

SELECT c.name FROM sys.tables t 
 INNER JOIN sys.columns c
    on c.object_id = t.object_id
    WHERE t.name = @table

answered Jun 1, 2014 at 14:09

Horaciux

6,5152 gold badges26 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrei Bozantan · Accepted Answer · 2014-06-03 12:13:12Z

0

If you can use a cursour (i.e. you can use Transact-SQL), then the sp_describe_cursor_columns (http://technet.microsoft.com/en-us/library/ms182755(v=sql.105).aspx) may help you.

If you want to do this from outside SQL Server, all database access technologies provide some kind of API to access metadata for a result set.

answered Jun 3, 2014 at 12:13

Andrei Bozantan

3,9612 gold badges33 silver badges41 bronze badges

Collectives™ on Stack Overflow

Return ColumnNames from Select query in SQL Server?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related