All articles: General SQL

Checkout our self-help content, created by our top Experts!
How to Handle Error Message 130 in SQL Server – Querychat
In the article, we will learn how to avoid error message 130 in SQL Server. Moreover, this article will provide examples of how to perform aggregate functions on aggregate and subquery expressions. SQL Server throws an error 130 showing us a message as “cannot perform an aggregate function on an...
How to Calculate the Total Number of Days in SQL Server – Querychat
In the article, we learn how to calculate the number of days in SQL Server. It provides examples of counting days between two dates using the DATEDIFF function and also the DATEADD function to filter dates. SQL Server provides several built-in functions in the T-SQL code that we can use...
The Difference Between FLOAT vs REAL Data Type in SQL Server – Querychat
In the article, we find out and learn how numeric or decimal values ​​are represented as FLOAT and REAL data types in database tables. Providing examples of how to embed FLOAT and REAL data types in a table, filling in and calculating the values ​​between these data types. The right...
How to Change the Existing Database Files to a New Path in SQL Server – Querychat
The article explains step by step in moving the current database and log files from a stand-alone database in SQL Server to a new path or another folder. Providing examples of changing the database files location using Transact-SQL Moving SQL Server database files can be done in two ways: 1....
How to Create and Call Deterministic Functions in MySQL – Querychat
In the article, we learn how to create the Deterministic function in MySQL. Providing examples of how to perform global settings and call the function. MySQL allows us to create stored functions and call them. It contains a collection of SQL commands/expressions in the form of routines that are stored...
How to Retrieve Column Information in SQL Server – Querychat
In the article, we learn how to retrieve column information of objects in SQL Server using a system stored procedure named sp_columns. Examples of using this stored procedure to get the column information of tables and views are provided. SQL Server provides the sp_columns system stored procedure that is used...
SQLite vs MySQL – Querychat
In this article, we will cover the comparison between the SQLite, and MySQL databases, basic knowledge about them, their benefits and differences.  Deciding where to store sensitive transactional data becomes crucial when we want free or low-cost database management software. That why it is important to find a good database...
What are the WMI and WQL Query? – Querychat
In this article, we will discover what the WMI and WQL query is in a nutshell. Also, we will list some of the most common keywords of the WQL. What is WMI? MWI stands for Windows Management Instrumentation. WMI is an interface that provides interoperability with system components. Using this...
How to Combine Autonumbers and Strings using CAST in SQL Server – Querychat
In this article, we learn how to combine autonumbers and strings with letters and numbers in SQL Server using an autogenerate function. Examples of how to cast numbers into strings are also included. Currently, there are many types of autonumber available. The most commonly used is int autoincrement that has...
How to Set NLS_DATE_FORMAT for the Session in Oracle – Querychat
In this article, we will discover what is NLS in Oracle. We will learn what this acronym stands for and what the NLS data format is. Also, we will get to know how it can be set in Oracle for the user session. NLS in Oracle: what is it? NLS...
1 2 18 19