Select columns with NULL values only

by

Here is the sql 2005 or later version: Replace ADDR_Address with your tablename.

declare @col varchar(255), @cmd varchar(max)

DECLARE getinfo cursor for
SELECT c.name FROM sys.tables t JOIN sys.columns c ON t.Object_ID = c.Object_ID
WHERE t.Name="ADDR_Address"

OPEN getinfo

FETCH NEXT FROM getinfo into @col

WHILE @@FETCH_STATUS = 0
BEGIN
    SELECT @cmd = 'IF NOT EXISTS (SELECT top 1 * FROM ADDR_Address WHERE [' + @col + '] IS NOT NULL) BEGIN print ''' + @col + ''' end'
    EXEC(@cmd)

    FETCH NEXT FROM getinfo into @col
END

CLOSE getinfo
DEALLOCATE getinfo

More Related Contents:

  1. T-SQL: Opposite to string concatenation – how to split string into multiple records [duplicate]
  2. Function to Calculate Median in SQL Server
  3. What’s the difference between a temp table and table variable in SQL Server?
  4. Sql Server string to date conversion
  5. How to export data as CSV format from SQL Server using sqlcmd?
  6. Query to list number of records in each table in a database
  7. SQL Server Text type vs. varchar data type [closed]
  8. Escape a string in SQL Server so that it is safe to use in LIKE expression
  9. Limitations of SQL Server Express
  10. SQL time difference between two dates result in hh:mm:ss
  11. Storing files in SQL Server
  12. Dapper.NET and stored proc with multiple result sets
  13. “order by newid()” – how does it work?
  14. Import ‘xml’ into Sql Server
  15. Query times out when executed from web, but super-fast when executed from SSMS
  16. T-SQL Dynamic SQL and Temp Tables
  17. Efficient ISNUMERIC() replacements on SQL Server?
  18. How to determine total number of open/active connections in ms sql server 2005
  19. Login to Microsoft SQL Server Error: 18456
  20. Adding a query hint when calling Table-Valued Function
  21. Find non-ASCII characters in varchar columns using SQL Server
  22. Violation of UNIQUE KEY constraint on INSERT WHERE COUNT(*) = 0 on SQL Server 2005
  23. How can I determine in SQL Server if a dateTime range overlaps another
  24. Intermittent ODBC connection failures
  25. How to split a string after specific character in SQL Server and update this value to specific column
  26. SQL Server Query – groupwise multiplication
  27. SQL Server Configuration Manager cannot be found
  28. Getting week number off a date in MS SQL Server 2005?
  29. Set database collation in Entity Framework Code-First Initializer
  30. How do you get to limits of 8060 bytes per row and 8000 per (varchar, nvarchar) value?

Leave a Comment