<p>How do I select all the columns in a table that only contain NULL values for all the rows?  I'm using <strong>MS SQL Server 2005</strong>.  I'm trying to find out which columns are not used in the table so I can delete them.</p>

```
```
SELECT cols
FROM table
WHERE cols IS NULL
```
```