I know this is very silly question but I am not able to understand why sql server is not updating records having NULL value, if I run below query:
UPDATE Students SET Resultsstatus = 'Final' where Resultsstatus != 'Hidden'
I run the above queries in certain circumstances where I want to update result status as "Final" for all those students who has not result status as "Hidden". To update them, I am using above sql queries. But this query is working only for those records who has result status other than NULL.
For records where we have results status as NULL, sql server is not updating those records as "Final" using above query.
Can someone please let me know, what is wrong with above query? Why it is not updating those records who has current result status as NULL?
Thanks in advance
question from:
https://stackoverflow.com/questions/65938635/sql-server-not-updating-records 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…