Today we will see a very simple blog post about Adding Values Containing NULLs. During the consulting engagement of Health Check.
Earlier I had published a blog post about a puzzle SQL Puzzle – IN and IS NOT NULL – Strange Results. Today we will see a solution to strange results puzzle.
While my primary focus is on SQL Server Performance Tuning, we will see questions related to adding default value to the existing table.
Recently during the consulting engagement, I needed to create a query that Lists All the Nullable Columns in Database, which I am sharing.