Pregunta de entrevista de Xylem
Was asked a question about NULL handling in SQL Server. Ex: What is wrong with this query "SELECT Something FROM table WHERE value = NULL". Unfortunately, the interviewers had the wrong answer.
Respuesta de la entrevista
Anónimo
16 feb 2023
I responded that it depended on the ANSI NULL settings in SQL Server database. Which is the correct answer. This was not taken well by the interview team. Who were apparently expecting me to tell them the query was invalid.