Counting null values in all fields in the data

[Anonymous]

I have a database with over a hundred columns.

I need to get the percentage of null values in each one of those columns captured in a table.

What would be the shortest way to do this?