当前位置: 动力学知识库 > 问答 > 编程问答 >

sql server 2008 - SQL to return list of fields containing No data

问题描述:

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.

分享给朋友:
您可能感兴趣的文章:
随机阅读: