NULL

T-SQL NULL Value

---

NULL and Aggregation (AVG())

10 Dec, 2014  in T-SQL  tagged Aggregate / AVG() / Goog Practice / NULL / T-SQL by Peter Lalovsky

While we create the database architecture, we decide to use the special value NULL or replace it with empty string or zero. Later on the development stage we manipulate the data and when we need to aggregate, we have to keep in mind the NULL or “blank” columns. The funny […]

---

T-SQL: Manipulating NULL value

9 Dec, 2014  in T-SQL  tagged Goog Practice / NULL / T-SQL by Peter Lalovsky

NULL values are special in SQL Server. They are not blanks or zeroes, but “Nothing” as they don’t take space in the database (table columns) and in the memory (variables). VBA uses the same word (Nothing) for NULL. The usage of NULL is a great discussion between developers and DBAs […]

---