/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

20 votes142 views1 answer
Get all table name in sql through php
SQL
1 vote153 views1 answer
Mysql list bigger table
SQL
7 votes150 views1 answer
Minecraft forge server host
SQL
49 votes228 views6 answers
Get duplicate records in sql
SQL
37 votes149 views3 answers
Postgresql insert column
SQL
40 votes216 views6 answers
Update table mysql
SQL
2 votes171 views1 answer
Cannot return non-composite value from function that returns composite type
SQL
0 vote158 views1 answer
Postgresql print sessions using the database
SQL
1 vote194 views1 answer
How to check all scheduled jobs in oracle
SQL
0 vote150 views1 answer
Dns slave zone convert
SQL