Display all fields with null values in a particular row in SQL Server

0 votes

1 answer

1923 views

sql-server-2012 null row fields isnull

                          I have a requirement where I want to fetch and display all the fields with NULL value for a particular row in the table.

Some thing like:

    select 'all columns with NULL' 
       from table_xyz 
       where primary_key='pk_row2';

I use SQL Server 2012. Please help achieve this.

Asked by Shreesha (1 rep)

Mar 12, 2019, 02:00 PM
Last activity: Mar 12, 2019, 03:29 PM

Display all fields with null values in a particular row in SQL Server

Related Questions