Get the NULL percentage of values in a specific table dynamically

  • Article

 

Nothing really fancy, but a small script I was now asked twice for. So I thought I publish it for the public and for the reference for others. It simply calculates the percentage of NULL values for a specific table in all columns. The last request was originated from the post here.

Be aware that this will scan the table entirely and might need some time for coming back.

You will get each column with an integer value as the percentage. This script will work on any version of SQL Server (except CE).

You find the script here.

-Jens