How to find the records having NULL values

Database
Enthusiast

How to find the records having NULL values

My table is having 250 columns, i need to retrieve the records having NULL values, few of the columns

having NULL Constraint, so i left those columns in my query.

SEL * FROM TableName WHERE Col1 is NULL or Col2 is NULL or Col3 is NULL... or Col250 is NULL

Can anyone help me to find the records having NULL values?

1 REPLY
Enthusiast

Re: How to find the records having NULL values

In my point of view I think thats the only way of finding the records with null value in any of the column i.e. ignoring the columns with not null constraint and checking for the NULL values in the rest of the columns...