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?
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...