How to Use SQL Server T-SQL Function SUM: 5 Use Cases
The T-SQL SUM function is one of the fundamental functions. Its purpose is to calculate the sum of...
SQL SELECT DISTINCT: Performance Best Practices
Is SQL DISTINCT good (or bad) when you need to remove duplicates in results? Some say it’s good and add DISTINCT when...
SQL OR Statement: The Basics
Now and then, you need to create a complex SQL query using multiple statements together. While these query types can be tedious to create,...
How to Use SQL SUM Function
SQL is a powerful and widely-used programming language for data storage, retrieval, and...
User-Defined Functions in SQL Server
User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of. Although they are very useful in many...
SQL BETWEEN-Smart Tips to Scan for a Range of Values
SQL BETWEEN is an operator used to specify a range of values to test. The returned value can be inclusive or within the range. Or it can be...
SQL Server ORDER BY Clause: The 5 Do’s and Don’ts to Sort Data Like a Pro
Ugly. That’s what unsorted data looks like. We make data easy for the eyes by sorting them. And...
Overview of T-SQL PRINT Statement
PRINT statements are crucial in any programming language. They will allow the routine or program that you are running to dump some type of...
GROUP BY in SQL Server: 3 Easy Examples to Group Results
Grouping is an important feature that helps organize and arrange data. There are a lot of ways to do it, and one of the most effective...
How to Comment MySQL Code: Best Practices
Comments are used to add information to the code. It is mostly ignored by the compiler, but human...
