how to get count of number of columns returned by a query

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi All,

I have a scenario where i want to get the number of columns returned by a query.

For e.g.

SQL

select * from
(select 1 as col1, 2 as col2, 3 as col3, 4 as col4) tab1

This has 4 columns so I want output as 4

select * from
(select 1 as col1, 2 as col2) tab1

This has 2 columns so I want output as 2

Is there a way to achieve this ...

Any help would be much appreciated.

Regards,
Gopal

Posted 13-Sep-11 3:16am

gopalgupta

Add a Solution

Comments

Om Prakash Pant 13-Sep-11 9:24am

you can get number of columns for a table, for a select query i don't think you will get columns from sql server.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Answer 1 · 2011-09-13T03:18:00

Solution 1

Instead of doing it in your SQL, do it in your application code by checking the DataTable.Columns.Count property.

Posted 13-Sep-11 3:18am

#realJSOP

Updated 13-Sep-11 3:19am

v2

Comments

gopalgupta 13-Sep-11 9:19am

Thnx but I have to do this in the back end ....

Mehdi Gholam 13-Sep-11 10:06am

You can do the above on your backend also.

Mehdi Gholam 13-Sep-11 10:06am

My 5!

how to get count of number of columns returned by a query

1 solution

Solution 1

Add your solution here

Preview 0

how to get count of number of columns returned by a query

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us