I show a dynamic SQL query that shows the number of rows that contain NULL in a certain column.

For this month's T-SQL Tuesday, we're talking about procedures and functions.

See several examples supporting the idea that you should use catalog views, not INFORMATION_SCHEMA, in SQL Server.