Reading Time: 11 minutes A proper understanding of NULL is absolutely essential for writing accurate queries that return accurate results. When you are first starting out with SQL Server, you might have these assumptions about NULL that are not quite right, or maybe flat out WRONG. If you misunderstand how SQL treats NULL, you Continue Reading
SQL Server character data types (and the differences between them)
Reading Time: 8 minutes When I was first learning how to query and develop databases using T-SQL, I would find myself confused between the different character (aka string) data types available to us. I would ask myself questions like: “What’s the difference between CHAR and VARCHAR?“ Or maybe: “What’s the difference between CHAR and Continue Reading