All articles: Data Manipulation Language (DML)

Checkout our self-help content, created by our top Experts!
SQL CASCADE with Example – Querychat
Referential integrity establishes the relationship between parent and child tables. We can do this by using the Primary Key and Foreign Key relations. Referential Integrity ensures database consistency. In this tutorial, we will learn what is referential integrity, how to use MySQL ON DELETE CASCADE, MySQL ON UPDATE CASCADE, and...
What is a file table in SQL Server? – Querychat
In this article, we will cover what SQL Server FileTable is, what is its main structure, and how to manage it with some examples. A FileTable works as a special table for Windows applications to access, with a fixed, pre-defined schema. It can store directory and files information, such as...
Query execution plan in Oracle – Querychat
In this article, we will understand the basics of the Oracle SQL*Plus explain plan execution, and its use to tune SQL statements. Usually, when running huge, complex processes, performance may decrease depending on how well the programming code works. To identify any problem regarding the process performance, the recommendation is...
How to Convert DATETIME to DATE in SQL Server – Querychat
In this article, we will discover how to convert the DATETIME format into the DATE using the CONVERT() and CAST() functions. In addition, we will take a look at the comparison between these two functions. When we need to convert the DATETIME to DATE Let’s compare two formats. DATETIME is...
How to Work with Multiple Databases in SQL Server – Querychat
In this article, we will check on how to work with multiple databases into the same server and other servers, and reviewing some examples in SQL Server. We usually work with different kind of information and its common that its location will be in different databases. There are several benefits...
Import Text Files into MySQL – Querychat
MySQL offers us the possibility to import data from external files other than a file with the  ".sql" extension. We can use TXT or CSV files with organized data to populate our tables. To achieve this, we will take a look into the options accepted by the LOAD DATA INFILE...
How to Import XML into SQL Server – Querychat
In this article, we will learn how to import data from XML to SQL Server through a practical example. Import XML to SQL Server To import data from XML to SQL Server, we need two things, the data in XML format and a table in SQL Server where the data...
What is the MS Access Split Function – Querychat
In this article, we will discover what the MS Access Split function is, what the syntax of this function is and also we will look at the detailed examples of its use in VBA code.  The MS Access Split function syntax At times, we need to divide, for example, a...
How To Use The PostgreSQL Max Function – Querychat
Databases have built-in aggregate functions that perform basic as well as advanced aggregation and summary operations, generally on numeric data. PostgreSQL too has several standard aggregate functions like SUM, COUNT, MIN, MAX, and AVG, which are a standard feature of SQL. In this article, we will learn the Postgresql max...
Oracle Error: Inserted value too large for a column – Querychat
This article discusses the ORA 01401 or value too large for a column error in Oracle, which happens because we try to insert a string value that is larger than the column's size. We will also learn the steps to resolve it. In addition, we will take a look at...
1 2 9 10