/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

0 vote267 views1 answer
Google sheets filter rows above current cell
SQL
4 votes264 views1 answer
Oracle change nls_date_format permanently
SQL
2 votes331 views1 answer
Find column in all stored procedures sql server
SQL
0 vote284 views1 answer
Kill a pid redshift
SQL
0 vote283 views2 answers
How to generate a unique random number in mysql
SQL
0 vote269 views1 answer
Install ms sql server management studio
SQL
1 vote270 views2 answers
Mysql join two tables
SQL
0 vote283 views1 answer
Sql bild in function
SQL
0 vote274 views1 answer
Add colum date in sql
SQL
1 vote273 views1 answer
Sql server 2016 reseed identity
SQL