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

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 a script with T-SQL Loops, and you want...
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...
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 learn is MySQL CREATE TABLE statement....
Read More

Difference Between DELETE and TRUNCATE Table in SQL Server

Database development, Statements, Tables

Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE...
Read More
Close