Tag: t-sql statements

Getting Started with the SQL Server T-SQL CASE Expression Statement

T-SQL

SQL Server CASE expression is very useful in returning an output based on some conditional matching...
Read More

How to Use SQL Server T-SQL Function SUM: 5 Use Cases

Database development, Statements

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 –...
Read More

SQL ORDER BY: The 5 Do’s and Don’ts to Sort Data Like a Pro

Database development, Statements

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...
Read More

Overview of T-SQL PRINT Statement

Database development, Statements

PRINT statements are crucial in any programming language. They will allow the routine or program...
Read More

Guide for CTE in SQL Server

Database development, Tables

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...
Read More

Understanding DROP TABLE IF EXISTS SQL Statement

Database development, Statements

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...
Read More

An Overview of the PRINT Statement in SQL Server

Database development, Statements

The SQL PRINT statement serves to display the user-defined message. For example, you are developing...
Read More

How to Round (UP/DOWN) in SQL Server – 5 Useful Tips

Database development, Statements

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...
Read More

SQL Server Delete Statement: How to Remove One or Multiply Rows from the Table

Database development, Statements, Tables

The right application of the DELETE statement for data removal is crucial, and it involves lots of issues. Still, there are standard...
Read More

CREATE TABLE MySQL vs T-SQL with Syntax Examples

Database development, Statements, T-SQL, Tables

Are you a T-SQL developer learning the basics of MySQL? Then, one of the things you might want to...
Read More
Close