SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test1
(
s_no int not null,
name varchar(10) not null,
address varchar(10) null,
emailid varchar(100) null
)
  
insert into test1 (s_no, name)
values (1,'A'),(2,'B'),(3,'C')


SELECT *  FROM [dbo].[test1]


s_no
name
address
emailid


1
A
null
null

2
B
null
null

3
C
null
null


create procedure ShowOnlyFilledColumns (@tablename varchar(100)) as
begin
     set nocount on

     declare @column_list varchar(8000),
             @counter int
     set @column_list = ''
     set @counter = 0
     while (Select max(colid) from syscolumns where id = object_id(@tablename) and isnullable= 0) > @counter
     begin
          select @counter = min(colid) from syscolumns where id = object_id(@tablename) and isnullable= 0 and colid > @counter
          select @column_list = @column_list + ',' + (Select name from syscolumns where id = object_id(@tablename) and isnullable= 0 and colid = @counter)
     end
     select @column_list = SUBSTRING(@column_list,2,len(@column_list))
     declare @sql varchar(8000)
     select @sql = 'select ' + @column_list + ' from ' + @tablename
--print @sql
     exec (@sql)     
end
exec ShowOnlyFilledColumns 'test1'


s_no
name


1
A

2
B

3
C


drop table test1

s_no	name	address	emailid
1	A	null	null
2	B	null	null
3	C	null	null