All articles: Others

Checkout our self-help content, created by our top Experts!
Access VBA: Count the Records in a Recordset – Querychat
One of the most basic questions we can ask about a table or other recordset is how many records there are within it. In Access, we find that count using the RecordCount property of the  recordset object. This article shows how to invoke that property in a few steps.  A...
What are the SQL Server Express Database limitations – Querychat
In this article, we will approach the SQL Server Express edition benefits and limitations. SQL Server, as a paid enterprise tool, can manage big amounts of data and can grow as much as it is needed. But if the scope is set on a lesser scale, Microsoft distributes free editions...
How to measure performance in MySQL – Querychat
In MySQL, measuring performance consists of tests that can check for query speed, how processes are running or if there can be any improvement done.  These improvements can be of using more table indexes to decrease execution time, removing unnecessary joins or where clauses, and updating settings that can have...
JDBC drivers for SQL Server – Querychat
This article will focus on showing the JDBC driver basics, how the Java.sql.sqlexception works and the given example ‘java SQL SQLException no suitable driver found’ error, and the possible solutions for it. JDBC acronym stands for Java Database Connectivity, which is a Java API provided by Microsoft and included in...
Is the mysql_select_db function obsolete? – Querychat
The mysql_select_db function was declared obsolete in PHP version 5.5 and worked until PHP version 7.0. Which means that PHP versions released before 7.0 are still compatible with mysql_select_db. But as of version 7.0, we can no longer use the mysql_select_db function. Since the mysql_select_db function no longer works in...
SQL Server xp_cmdshell – Querychat
This article explains about xp_cmdshell, which is an extended stored procedure in SQL Server. This procedure is by default, disabled for security reasons. We are going to learn how to turn it on by using sp_configure or  SSMS GUI. There are also examples of how to use xp_cmdshell in T-SQL...
How To Use MySQL JDBC – Querychat
Using JDBC as a protocol allows programming languages like Java to connect to a MySQL Database. In this article, we discuss how to construct the JDBC URL to be able to connect to a database in MySQL through sample Java files and lines in the Command Prompt. Programming languages like...
Stored Procedure by Using sp_helptext – Querychat
The sp_helptext is a system stored procedure that is used to view the text definition of any SQL Server objects that contain code. It can be used for unencrypted user-defined stored procedures, functions, views, triggers, even system objects such as system stored procedures. This article demonstrates how to use sp_helptext...
SQL Server Debug Stored Procedure – Querychat
This article shows how to debug a stored procedure in SQL Server 2008 or SQL Server 2012 and later versions. In this tutorial, we will use the SQL Server Management Studio to debug the stored procedures. First things first, let's create a stored procedure for debug purposes. The below query...
How to upgrade MySQL version – Querychat
In this article, we are going to review the process of updating the MySQL version from 5.5.60 to 5.5.62. First, we are going to install version 5.5.60 of MySQL. If you do not have the installer, you can download it from the official site: https://downloads.mysql.com/archives/installer/ Image 1. MySQL Installer download...
1 2 14 15 16 17