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.
A Very popular question I often here whenever I am presenting at the developer conference – How to Change Column Property From NULL to Not NULL Value?