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

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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!