/SQL/How to find columns with null values in sql

How to find columns with null values in sql

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

Source: stackoverflow.com

Similar codes

2 votes330 views2 answers
Mysql all columns
SQL
1 vote362 views1 answer
Sql server kill all connections
SQL
0 vote350 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
1 vote355 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
1 vote325 views1 answer
Mysqli connect
SQL
2 votes388 views3 answers
Mysql pass command from command line
SQL
0 vote367 views1 answer
Mysql trigger to delete old data
SQL
3 votes380 views2 answers
Laravel tosql with bindings
SQL
0 vote370 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote382 views1 answer
Java sql insert return id
SQL