Count number of NULL values in each column in SQL

by

You should use execute:

DECLARE @t nvarchar(max)
SET @t = N'SELECT '

SELECT @t = @t + 'sum(case when ' + c.name + ' is null then 1 else 0 end) "Null Values for ' + c.name + '",
                sum(case when ' + c.name + ' is null then 0 else 1 end) "Non-Null Values for ' + c.name + '",'
FROM sys.columns c 
WHERE c.object_id = object_id('my_table');

SET @t = SUBSTRING(@t, 1, LEN(@t) - 1) + ' FROM my_table;'

EXEC sp_executesql @t

More Related Contents:

  1. Get Parent with multiple children in desc order
  2. How can I schedule a job to run a SQL query daily?
  3. Convert Month Number to Month Name Function in SQL
  4. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  5. Reset identity seed after deleting records in SQL Server
  6. How to avoid the “divide by zero” error in SQL?
  7. Multiple INSERT statements vs. single INSERT with multiple VALUES
  8. Limit on the WHERE col IN (…) condition
  9. Removing leading zeroes from a field in a SQL statement
  10. Get day of week in SQL Server 2005/2008
  11. Getting result of dynamic SQL into a variable for sql-server
  12. Simple Query to Grab Max Value for each ID
  13. SQL Server: Extract Table Meta-Data (description, fields and their data types)
  14. SQL Server 2008: how do I grant privileges to a username?
  15. Dynamic Pivot Table in SQL Server
  16. Optimized SQL for tree structures
  17. How to insert a blob into a database using sql server management studio
  18. Incorrect syntax near ”
  19. Execution sequence of Group By, Having and Where clause in SQL Server?
  20. How Can I Sort A ‘Version Number’ Column Generically Using a SQL Server Query
  21. Aggregate function in an SQL update query?
  22. Converting Select results into Insert script – SQL Server
  23. Is it possible to execute a text file from SQL query?
  24. SELECT query with CASE condition and SUM()
  25. How to pass a temp table as a parameter into a separate stored procedure
  26. Select statement to return parent and infinite children
  27. SQL Server Query time out depending on Where Clause
  28. SQL Server search using like while ignoring blank spaces
  29. How do I compare two columns for equality in SQL Server?
  30. Getting warning: Null value is eliminated by an aggregate or other SET operation

Leave a Comment