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...
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 learn is MySQL CREATE TABLE statement....
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...
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 the details! You can read all sorts of...
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...
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 its data and indexes associated with it....
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...
