All articles: Others

Checkout our self-help content, created by our top Experts!
How to use mysqli_real_connect command – Querychat
In this article, we will understand how to work with the mysqli_real_connect function, including simplified examples for better understanding. The mysqli_real_connect function allows the connection to a MySQL engine, returning TRUE if the connection was successfully made, or FALSE if there was a problem. There are certain considerations when comparing...
DBMS_SQL Basics: Working with Cursors in PL/SQL – Querychat
In this article, we will understand how to work with the SQL DBMS package in PL/SQL, focusing on how to define a cursor with methods such as DEFINE_COLUMN, COLUMN_VALUE, OPEN_CURSOR, PARSE, EXECUTE, FETCH_ROWS and CLOSE CURSOR objects. DBMS_SQL DEFINE_COLUMN The DEFINE_COLUMN is used to define each fetched column from a...
BIND_VARIABLE, BIND_ARRAY and EXECUTE_AND_FETCH in PL/SQL – Querychat
In this article, we will understand the basics of how to work with the SQL DBMS package in SQL Server, checking the basics of the BIND_VARIABLE, BIND_ARRAY and EXECUTE_AND_FETCH methods, including simplified examples, for better understanding. DBMS_SQL EXECUTE_AND_FETCH The EXECUTE_AND_FETCH function works as the EXECUTE and FETCH_ROWS, which retrieves rows...
What is the difference between SQLite and MySQL – Querychat
In this article, we will find out the difference between SQLite and MySQL, thus solving the eternal struggle MySQL vs SQLite. We will go through such items as supported data types, advantages, and disadvantages, and find out when to use one or another database management system. MySQL vs SQLite data...
How to use the SQL Server Management Studio Query Designer – Querychat
We often face the problem that we have to imagine the table representation from our database in order to complete the query and also we need to imagine what our changes can look like ultimately.   There is a wonderful way to solve this problem, that is why in this article...
How to change the column order in the SQL Server – Querychat
In this article, we will learn how to change the column order in the SQL Server using the SQL Server Management Studio. Also, we will show step by step how we change the column position. What is SQL Server Management Studio SSMS is an environment where we can manage SQL...
Sql server credentials – Querychat
There are 2 ways to connect it to the SQL Server Database. One is SQL Server Authentication and the other is windows authentication. The SQL Server database can be connected by the SQL Server management studio. Click on connect to the server in the SQL Server management studio.  Image-1: SQL...
Creating a backup for the transaction log file in SQL Server – Querychat
In this article, we will learn the steps for the transaction log backup process, including PowerShell and Transact-SQL examples. The transaction log allows the SQL server to store all transactions and modifications made to the database, which is likely to increase its size in no time. Using the backup process...
How to migrate a table from MS Access to MySQL – Querychat
In this article, we will learn how to migrate a table from MS Access to MySQL. To achieve our goal we will use the MySQL Connector/ODBC. If you do not have the Connector installed, you can download it from the official site: https://dev.mysql.com/downloads/connector/odbc/ Select the appropriate version for your operating...
Using System.Convert in C# – Querychat
System.Convert is a C# class library that allows conversion between different data types. It can also be used to convert generic data to culture-specific text (ex. dates). Exceptions Some of the conversions of the System.Convert are invalid and performing one will cause exceptions to be thrown.  InvalidCastException InvalidCastException is thrown...
1 2 10 11