Understanding SQL Server ALTER TABLE ADD COLUMN Statement
This article describes the SQL Server ALTER TABLE ADD COLUMN statement. The purpose of this...
Using INNER JOIN to Combine SQL Server Tables and Display Them in ASP.NET Webforms
This article describes the ways of using an INNER JOIN to combine results from two tables in the SQL Server database and display them in an...
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...
Fundamentals of Managing Datafiles in SQL Server
Introduction Datafiles are physical objects that constitute the most important part of the database system since they contain actual data....
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...
Five Different Methods To Start, Stop, And Restart SQL Server Services
When we install the SQL Server, it also installs the following services: SQL Server database engine service to manage and access data in...
Install and Configure SQL Server 2019 on Windows Server 2016
SQL Server 2019 was introduced in November 2019. The RTM version of SQL Server 2019 is 15.0.2000.5. To learn about the new features...
Basics of SQL Server Management Studio (SSMS) – Part 1
This article aims to share the basics of SQL Server Management Studio, commonly known as SSMS, and...
