Getting Started with the SQL Server T-SQL CASE Expression Statement
SQL Server CASE expression is very useful in returning an output based on some conditional matching...
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 all values in the specified column –...
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 that’s what SQL ORDER BY is for. Use...
Overview of T-SQL PRINT Statement
PRINT statements are crucial in any programming language. They will allow the routine or program...
Guide for CTE in SQL Server
The Common Table Expression aka CTE in SQL Server provides a temporary result set in T-SQL. You can refer to it within a SQL Select, SQL...
Understanding DROP TABLE IF EXISTS SQL Statement
The T SQL DROP TABLE IF EXISTS statement is used to drop existing database objects. In this article, we are going to study the various use...
An Overview of the PRINT Statement in SQL Server
The SQL PRINT statement serves to display the user-defined message. For example, you are developing...
How to Round (UP/DOWN) in SQL Server – 5 Useful Tips
We’ve been taught to round numbers since we were kids. When you round off 1.15 to the nearest tenths, will it be 1.2 or 1.1? Using the...
SQL Server Delete Statement: How to Remove One or Multiply Rows from the Table
The right application of the DELETE statement for data removal is crucial, and it involves lots of issues. Still, there are standard...
CREATE TABLE MySQL vs T-SQL with Syntax Examples
Are you a T-SQL developer learning the basics of MySQL? Then, one of the things you might want to...
