Loading

T-SQL Stored Procedure

SUMATHI M

How to remove the two or more field if it contains any null values?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
if you are talking about normal SQL then you can filter the row.
select * from table where Col 1 is not null && col2 is not null;
Nitin Sontakke5y ago
Hello,

If you could please be bit more specific as to what exactly you want to achieve here.

Please try to step into the shoes of someone is trying to answer and see how vague your question sounds.

Also, please detail the scenario. There could be any number of approaches to arrive at solution.

Provide some code, if already written. Share some data. Show expected output, etc.