How Can I use a Count Query to get the Sum of Columns

Published by: Riya (11/4/2008 2:48:54 PM)

I am writing a program where i need to know the number of columns in the table upfront so how can I use a count query to find the sum of all the columns in a table and read the expression? Please help me with an answer. Can I user count(column) as column_count here?

 

Most Popular Articles

• How can I run my Stored Procedure in SQL Server 2005
• SQL Join Query for Microsoft Access Database
• What is the use of nolock condition in SQL Query
• How can I Truncate my Database Log to Reduce the Size
• when to use cast and when to use convert operator in SQL

Can I Concatenate String from a Column and Get Back One Row >>

<< Ways to Know the Version of MDAC I am Running