select table except NULL rows

Select any number of columns tables dynamically — except NULL rows (SQL SERVER)

https://gist.github.com/iraklidd/44ba7128fb38b6c6f36af7bc6cfddfd2

CREATE PROCEDURE dbo.notnullcolumns
@t varchar(128)
AS
BEGIN
declare
@c_name varchar(300),
@sql varchar(max)
declare c cursor for
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = @t;
set @sql = 'select * from '+@t+' where 1=1';
open c;
fetch next from c into @c_name;
set @sql = @sql + ' AND (' + @c_name + ' IS NOT NULL';
while @@FETCH_STATUS=0
begin
fetch next from c into @c_name;
set @sql = @sql + ' AND ' + @c_name + ' IS NOT NULL';
end;
close c;
set @sql = @sql + ')';
deallocate c;
EXEC (@sql)
END