select case when null=null then 'Yes' else 'No' end
what is output and why
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Shiva LenkaPosted Feb 9, 2018, 7:03 AM
go
select case when null=null then 'Yes' else 'No' end
output'YES'
SET ANSI_NULLS on
go
select case when null=null then 'Yes' else 'No' end
output'NO'
Ravi PatelPosted Feb 9, 2018, 6:49 AM