All articles: Others

Checkout our self-help content, created by our top Experts!
How to Install MySQL in Windows – Querychat
MySQL, developed by Oracle, is a SQL database management system. This article will describe the MySQL installation guide. First, it is important to check if the platform used is suitable for running MySQL, supported platforms check the information on this website: https://www.mysql.com/support/supportedplatforms/database.html. It is also essential to know which MySQL...
Get the Last Inserted ID in SQL Server by Using SCOPE_IDENTITY – Querychat
This article explains how to get the last value of an identity column by using the SCOPE_IDENTITY function. We are also going to have a look at a brief comparison between the SCOPE IDENTITY function with other similar functions such as IDENT_CURRENT and @@IDENTITY. Some simple examples are provided for...
SQL Server Installation – Querychat
This article will cover the installation process from the SQL Server 2016 in a Windows operating system, following its installation wizard. Its current installation process allows installing the SQL Server components as a whole. There are different editions of SQL Server, and its installation process differs from one another. The...
SQL Server: Configuration options – Querychat
We use configuration options to manage and optimize SQL server resources. These configuration options can be managed through sp_configure procedure or SQL Server Management Studio.  In this article, we will look at examples to manage a few popular configuration parameters in SQL server.  Popular configuration parameters in SQL Server Let...
Migration Assistant – Querychat
The migration processes from other databases to SQL server is made a lot easier with the help of SQL Server Migration Assistant (SSMA) tool. There are migration assistants for MySQL, DB2, Sybase, Access and Oracle. In this article, we will look at migration assistants for Access and MySQL with proper...
MySQL Timeout Variables – Querychat
There are many timeout variables in MySQL which play essential roles in protecting our database server. They define how long the connection, or transaction or, SQL threads can wait based on the setting of each variable. Understanding each of them can help us troubleshoot the issues related to timeout. View...
How to Use Parameters in SQL Server Queries – Querychat
In some cases, we may want to create a query that we can use many times, but with a different value each time. By providing parameters in our SQL, we can create a single query that serves up answers to lots of different questions. It adds flexibility to our database...
SQL Materialized views – Querychat
A materialized view in SQL is similar to a regular view. The only difference is that unlike a regular view, a materialized view exists physically, just like a table. In this article, we will see how to create a materialized view in SQL Server and MySQL. This article will use...
Fetching the result of MySQL queries in PHP – Querychat
In this article, we learn how to fetch the result of a MySQL query by using mysqli_fetch_row, mysqli_fetch_assoc, mysqli_fetch_array, and mysqli_fetch_object functions in PHP.   mysqli_fetch_row or fetch_row function The mysqli_fetch_row function fetches a row of the result set and returns it as an enumerated array. This function returns only a...
How to Connect to Oracle DB using SQL Plus – Querychat
SQL Plus is a free command line tool allowing us to interact with the Oracle database. Using SQL*Plus, we can perform queries, execute PL/SQL scripts, and run INSERT, UPDATE, and DELETE statements. In this article, we’re going to learn how to open SQL Plus by using the command line and...
1 2 15 16 17