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...
Difference Between DELETE and TRUNCATE Table in SQL Server
Many articles have been written to describe the difference between the SQL DELETE and SQL TRUNCATE statements. Moreover, it is one of the...
SQL UNION Cheat Sheet with 10 Easy and Useful Tips
Having a hard time with SQL UNION? It happens if the results you combined put your SQL Server into a standstill. Or a report that’s been...
Do You Make These Mistakes When Using SQL CURSOR?
For some people, it’s the wrong question. SQL CURSOR IS the mistake. The devil is in...
Understanding SQL Server ALTER TABLE ADD COLUMN Statement
This article describes the SQL Server ALTER TABLE ADD COLUMN statement. The purpose of this statement is to add a new column to an existing...
Understanding MySQL TRUNCATE TABLE by Practical Examples
MySQL TRUNCATE TABLE statement is a DDL statement used for removing all records from the MySQL table. When we run this command, it drops...
SQL DROP TABLE Statement and Various Use Cases
The SQL DROP TABLE statement serves to drop the table from the database. It removes the table and...
How to Parse Strings Like a Pro Using SQL SUBSTRING() Function?
Do you enjoy parsing strings? If so, one of the indispensable string functions to use is SQL SUBSTRING. It is one of those skills a...
Use Cases for SQL Server MERGE Statement: Syncing Online and History Tables
INTRODUCTION The SQL Server MERGE statement is an incredibly useful tool for carrying out DML operations based on comparing two tables or...
A Practical Use of the SQL COALESCE Function
This article talks about the practical use of the SQL COALESCE function regarding some professional...
