All articles: Others

Checkout our self-help content, created by our top Experts!
All articles Others
MS Access Round Function – Querychat
This article explains the Round function in MS Access that allows us to round a calculation to a given number of decimal places. Before using this function, we need to understand that the Round function in MS Access uses the Bankers’ Rounding algorithm. Various examples of rounding in Access query...
Comments in Oracle – Querychat
This article discusses the comments in Oracle. It includes how a comment can be added, viewed, updated and deleted from Oracle Objects. We may write complex code now and then, and later forgot why we wrote that code. One way to prevent this from happening is to write comments about...
SQL Server Read Only Database – Querychat
Read-Only Database, as the name suggests, allows only reading from the database. All other modification operations like insert, update, delete, etc. are not allowed in this type of database. In this article, we will discuss how we can make a SQL Server database Read-Only and a SQL Server read-only user....
How to store passwords in MySQL – Querychat
If you are a Database Administrator and want to protect your users' data with a strong and safe password or you are just interested in this topic, then in this article, we will learn how to store passwords in MySQL in several ways. MD5(str) function for storing passwords in MySQL...
How to install SSRS in Visual Studio 2017 – Querychat
If we want to use Visual Studio 2017 in order to build new or upgrade existing SSRS projects, we can't use the default version of Visual Studio 2017, since Microsoft Reporting Services are not a part of the default Visual Studio 2017 version. Due to that fact, we need to...
How to work with mysqli_fetch_object function – Querychat
In this article, we will learn how to work with the mysqli_fetch_object function with an example. The mysqli_fetch_object function returns the current row between the rows returned by the executed query. The row is returned as an object, and we can access the query columns as attributes of that object....
How to work with mysqli_affected_rows functions – Querychat
In this article, we will learn how to use the mysqli_affected_rows function. We will invoke it in two different ways, object-oriented and procedural style. First, we will create an Orders table, on which we will execute our queries. The table will have the following structure and content: CREATE TABLE `orders`...
How to display sql data in html – Querychat
In this article, we will learn a couple of techniques that will help us to display the data from a MySQL table in HTML. First, let's create a table in MySQL on which we will build our samples. The new table will be called Products and will have the following...
SQL Server SP_WHO2 – Querychat
SQL Server sp_who2 is a system stored procedure that provides information about the current users and sessions in an instance of SQL Server Database Engine. Along with sp_who2, there is another system stored procedure called sp_who which is the official and documented, but because of the more information returned by...
SSRS rdl file – Querychat
SSRS RDL file is a basic element in developing SSRS reports. RDL stands for Report Definition Language, so we can define it basically as an XML file which contains a report’s definition made out of visual and logical elements that we incorporate in a report: datasets, datasources, tables, graphs, images,...
1 2 4 5