SQL: 3 ways to find gaps and missing values
It is really common to have columns that stores sequences of numbers in database systems (specially in relational databases). Users[…]
Read more
Category: Transact-SQL functions
3 ways to remove duplicate data
Duplicate data can be generated in the database due to design error, software bugs or misuse by end users. Depending[…]
Read more
LEAD and LAG: accessing multiple rows without self join
LEAD and LAG are window functions that enable the simultaneous access to a table’s row and to other row related[…]
Read more
Coalesce, NVL, ISNULL, Case, … What should a I use?
There are a lot of options to use when testing for NULL values in SQL. One should use built-in functions[…]
Read more
Getting date and time parts from DateTime and SmallDateTime fields
Microsoft SQL Server supports several data types that can be used to store dates and times. Although some of them[…]
Read more