All articles: Data Query Language (DQL)

Checkout our self-help content, created by our top Experts!
SQL Server SOUNDEX and DIFFERENCE Functions – Querychat
The two functions, DIFFERENCE and SOUNDEX, both work with character strings in order to evaluate those that sound similar, based on English phonetic rules. In this article, we will discuss these functions, their use, and take a look at some examples of using them. T-SQL SOUNDEX and DIFFERENCE Finding similarities...
MySQL Format Function – Querychat
While manipulating data in MySQL, we often need to present a particular numerical value in some format that is different from the default one. This article elaborates on how to use the FORMAT function to change the default format of a numerical value. The Syntax of MySQL FORMAT Function The...
Views in SQL Server – Querychat
While developing databases and providing user access to data, sometimes it is very important to have the possibility to create virtual tables for both security and efficiency reasons. Those virtual tables are called views. This article elaborates on the advantages of views in SQL Server, as well as how to...
SP_REFRESHVIEW in SQL Server – Querychat
SP_REFRESHVIEW is a system procedure that enables us to update the view’s definition in SQL Server. In this article, we will learn about refreshing views in terms of using the SP_REFRESHVIEW stored procedure. What is SP_REFRESHVIEW? SP_REFRESHVIEW is a system procedure that we use when we want to refresh the...
Boolean Data in SQL – Querychat
In this article, we are going to learn how to insert and update boolean data in SQL. How we retrieve data using a boolean condition. Included examples can be executed in both SQL Server and MySQL. Boolean Data Some properties have only two options true or false, and yes or...
Understanding Oracle all_tab_columns – Querychat
Oracle stores all the information about tables, views, columns, triggers, and other database objects in Oracle’s build-in-views, also known as data dictionary tables. In this article, we will learn about Oracle’s ‘all_tab_columns’ data dictionary view and its structure. all_tab_columns Whenever a table or view is created or modified in a...
How to work with regular expressions in SQL Server – Querychat
In this article, we will learn how to work with regular expressions in SQL Server. We will build some example queries with different search patterns so we can get familiar with the search pattern design process. We are going to build our sample queries based on a table that we...
How to Split Comma Separated Values In SQL Server – Querychat
In this article, we will learn how to split comma separated values In SQL Server even though SQL Server does not have a native function to do so directly.  Some tables have columns whose values are concatenated. A very common example is a name column where the name and the...
Using SQL Server LIKE with Wildcards – Querychat
When filtering query results based on text values, sometimes we don't want a match on the entire value but only a partial match based on a pattern. To compare column values with a specified pattern, we need the LIKE operator. In this article, we will learn how to use this...
SQL Server PARSENAME – Querychat
In this article, we will learn the PARSENAME function, which is one of the metadata functions in SQL Server. It is used to retrieve a specific part of an object name. However, we will also take a look at how this function can be useful in other ways. SQL Server...
1 2 24 25