Obviously the ideal outcome would be to decide if you really need this option. It's a very old option and encourages poor NULL handling logic. In a normal SQL system, comparing anything to NULL returns NULL not true or false. This option changes that, but not for the better. Now that said, I understand you might have a bunch of code that depends on it. Given it's only recently deprecated (and I'm pretty sure it was in 2017, not 2022), I wouldn't be too worried about it disappearing on you. They also say that nowadays they try not to remove deprecated features. Most features deprecated 12 years earlier in 2005 are still present in the product. But I would encourage you to improve the logic in the code so that option is not required. You can easily apply slightly different logic in situations where you were depending upon this outcome, and at least those options would then live on without issue.
Microsoft deprecated - ANSI_NULLS OFF in SQL Server 2022. What will be the alternate for this option. As a deprecated feature this one will stop working in the upcoming SQL Server versions. So what will be the alternate for this option. I am happy to hear from Microsoft.
Thanks a lot for your reply. It is true that MS still contains all the past dated deprecated features, but as you said - we have lot of code bunch with these set of options. So we need to decide on it by providing systematic approach of handling NULL. As no one think about MS deprecating this option. I know it will not line it stop working from next release itself but in future it will definitely. Thanks Greg for your quick response.
Sign in to comment