1

Possible Duplicate:
SQL: Select columns with NULL values only
Find fields that aren't used (have all nulls)

I have a table with 400 feilds and 3 Bil rows out of which 100 of them have no values/data. Can some one please give me a sample example or suggestion on how to proceed to get the list of those 100 columns which has null for all the 3 Bil rows in that table. Thank you in advance.

Improve this question
1
Related questions
2224
How to return only the Date from a SQL Server DateTime datatype
2204
How to check if a column exists in a SQL Server table
1801
How can I delete using INNER JOIN with SQL Server?
Load 7 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.