Skip to main content
2 of 3
grammar, spelling
Andriy M
  • 23.2k
  • 6
  • 59
  • 103

Finding count of null values in 500 columns of a single table

I have 500 columns in a table in SQL Server. I want to find the count of null values in each column. Is there a way to do it using a cursor and dynamic SQL?

Gayathri
  • 11
  • 1
  • 2