I have below query inside sp.
select groupno,a from table1
where groupno <> 'Test'
It is not returning rows where groupno is null. I did recompile sp with SET ANSI_NULLS off. But it is not working. Any suggestions? Please help
thank you
I have below query inside sp.
select groupno,a from table1
where groupno <> 'Test'
It is not returning rows where groupno is null. I did recompile sp with SET ANSI_NULLS off. But it is not working. Any suggestions? Please help
thank you
select groupno,a from table1
where groupno <> 'Test' OR groupno is null
If yo want to match for two conditions then you have to specify that in the sql query.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.